… asked me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info… statements. For most simple cases information from SHOW INNODB STATUS is good enough. As for deadlock information we have similar information about last failed…
Post: Table locks in SHOW INNODB STATUS
June 8, 2010 By 1 Comment
… frequently I see people confused what table locks reported by SHOW INNODB STATUS really mean. Check this out for example: —TRANSACTION 0 4872… worry intention table locks you may observe in SHOW INNODB STATUS output, they almost never would be cause of your lock waits or deadlocks.
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…, see past deadlocks and the list of all open transactions. This is in your reach with one simple command — SHOW ENGINE InnoDB STATUS. On… for even simplest queries, or a huge deadlock. In such rare cases SHOW ENGINE InnoDB STATUS often fails to provide the necessary information. The…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… bas Solid does not yet have lock investigation tool as SHOW INNODB STATUS (at least) – so it is hard to tell what is… could proceed modifying them without causing deadlocks. For comparion here are InnoDB sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…deadlock. The locks in question are LOCK_global_system_variables and LOCK_system_variables_hash. Deadlock is possible when one connection issues SHOW…show the same issues, show similar issues (other InnoDB stat counters), show…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…-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: 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…
