June 18, 2013

Post: SHOW INNODB STATUS walk through

… people 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… left by Innodb developers so SHOW INNODB STATUS can also be used as debugging tool. Next section you will find in SHOW INNODB STATUS is…

Comment: SHOW INNODB STATUS walk through

[...] SHOW INNODB STATUS walk through | MySQL Performance Blog – June 15th ( tags: mysql innodb performance tuning database status monitoring reference ) [...]

Comment: SHOW INNODB STATUS walk through

[...] (翻译了mysqlperformance blog的文章,网址为http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/,英文不好,大家见笑) [...]

Comment: SHOW INNODB STATUS walk through

[...] also see something about this on www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/ by Peter [...]

Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

… matched: 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct… handle 0x7fddb84e0700, query id 16408 localhost root sleeping show engine innodb status Trx read view will not see trx with id >= 83C… more about PXC and go hands-on?   I will walk you through real examples on this and a lot more at my…