61,508 reputation
1060143
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 5 months
seen 26 mins ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Dec
13
wiki created ndbcluster description
Dec
13
wiki created ndbcluster excerpt
Dec
13
revised SQL Server commands to clear caches before running a performance comparison
Corrected grammar and punctuation
Dec
13
revised SQL Server virtual log size
added 6 characters in body
Dec
13
revised How do I output MySQL logs to syslog?
deleted 1 characters in body
Dec
13
comment MySQL InnoDB locks primary key on delete even in READ COMMITTED
With two completing locks, one has to be rolled back. It is possible that locks may linger. WORKING THEORY : the transaction that rolled back may retry and may encounter an old lock from the previous transaction that held it.
Dec
13
comment MySQL InnoDB locks primary key on delete even in READ COMMITTED
Please note that I mentioned the possibility of two rows existing in the same page for locking ( See Look back at information_schema.innodb_locks you supplied in the Question )
Dec
13
comment MySQL InnoDB locks primary key on delete even in READ COMMITTED
If just a single SQL statement is rolled back as a result of an error, some of the locks set by the statement may be preserved. This happens because InnoDB stores row locks in a format such that it cannot know afterward which lock was set by which statement : dev.mysql.com/doc/refman/5.5/en/innodb-deadlock-detection.html
Dec
13
revised MySQL InnoDB locks primary key on delete even in READ COMMITTED
added 29 characters in body
Dec
13
reviewed Reviewed Cannot start SqlLocalDB instance with my Windows account
Dec
13
reviewed Reviewed The distribution agent failed to create temporary files
Dec
13
reviewed Close Where to put utility (not administration) stored procedures in SQL Server?
Dec
13
reviewed Close Fatal NI connect error 12170
Dec
13
reviewed Close How to prevent SQL Server database server from running out of disk space?
Dec
13
revised Issue with connecting to the mysql database
added 264 characters in body
Dec
13
revised Issue with connecting to the mysql database
edited tags
Dec
13
answered Issue with connecting to the mysql database
Dec
13
comment Issue with connecting to the mysql database
Did this happen after upgrading to MySQL 5.5 ?
Dec
13
revised MySQL InnoDB locks primary key on delete even in READ COMMITTED
added 356 characters in body
Dec
13
answered MySQL InnoDB locks primary key on delete even in READ COMMITTED