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 this….05 non-hash searches/s This section shows insert buffer and adaptive hash status. First line shows status of insert buffer – segment size and…

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

…) ); Query OK, 0 rows affected (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE… thread handle 0x7fddb84e0700, query id 16408 localhost root sleeping show engine innodb status Trx read view will not see trx with id… more about PXC and go hands-on?   I will walk you through real examples on this and a lot more at my…