…number of connections all connections will be printed in transaction list, if you have large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… followed by a port number. That is the port number of the TCP connection that’…pull the oldest transaction that holds any locks from SHOW INNODB STATUS and assume that it’s the… –no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW INNODB STATUS and SHOW PROCESSLIST …
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
…number of latched pages in Innodb Buffer Pool, which is called when you run SHOW INNODB STATUS and SHOW STATUS. In this case for same of monitoring SHOW GLOBAL STATUS…of queries pile up waiting on locked innodb buffer pool mutex, so SHOW STATUS shows high number of…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…shows that accesses to the fields of buf_pool->stat are unprotected. These are buffer pool statistics counters: number of…lock (hg_intercepts.c:496) ==9090== by 0x74A32E: show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status…
