June 19, 2013

Post: SHOW INNODB STATUS walk through

SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL… which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS, …optimal – if you see more than 30% of log … buffer pool efficiency. 1000/1000 corresponds to 100% hit…