…-mysql-processlist plugin checks SHOW FULL PROCESSLIST for patterns that indicate similar problems to those discussed within InnoDB, but it can find…. Similarly to deadlocks and timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…id), UNIQUE KEY(username) ) ENGINE=InnoDB; Now consider the following sequence of… for key ‘PRIMARY’ (root@localhost) [test]> show status like ‘handler%’; *** some rows omitted *** +—————————-+——-+ | Variable_name | … going to end well; deadlocks, rollbacks, contention, and all …
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… of Percona’s earlier fast-recovery code. Added the –percona_innodb_doublewrite_path option to place the double-write-buffer into… before using it in query cache. Added a global Innodb_deadlocks counter to SHOW STATUS, based on a patch by Eric Bergen (issue #569288… Can’t compile 5.1.46 #573104 separate name in INNODB_SYS_TABLES table #580324 Security bug in upstream #586579 Percona…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…the proviso about the potential for increase in deadlock errors (see the slides/recording if you missed … does not work with rsync when the option innodb_data_home_dir is set to a …on an arbitrary expression that includes any SHOW STATUS and/or SHOW VARIABLES on the monitored MySQL server in question…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
…that is on the way, caused the deadlock situation. Resolved by grabbing Global Read Lock… wsrep position wasn’t stored into the InnoDB tablespace. Bug fixed #1084199 (Teemu Ollakka). Using… set wsrep_node_incoming_address might make “SHOW STATUS LIKE ‘wsrep_incoming_addresses’;” return the address…
