… 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 bug…replication … locking…with 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 replication…locks and reorganizes small portions of table…

