May 25, 2012

Post: Percona Server 5.1.59-13.0

… slave server in a replication environment, the process can…but has high overhead from locking rows only to undo …fix for MySQL bug #53761 (Wrong estimate for RANGE query with compound …AUTO_INCREMENT columns must be defined as keys, omitting key specifications and then adding them back in ALTER TABLE

Post: Percona Server 5.5.16-22.0

MySQL 5.5.16, including all the bugreplicationlockingwith SHOW VARIABLES. #830199 (Oleg Tsarev). Fixed assertion failure in InnoDB. #814404 (Yasufumi Kinoshita). Since AUTO_INCREMENT columns must be defined as keys, omitting key specifications and then adding them back in ALTER TABLE

Post: Heikki Tuuri answers to Innodb questions, Part II

…Also note the “Auto Increment Issue” is…with a large patch, and the ‘last’ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug…There have been several MySQL bugs opened about multi-…table on a separate computer, maybe a replicationlocks and reorganizes small portions of table