Archive for the ‘optimizations’ Category

SHOW ENGINE INNODB STATUS;

Октябрь 2nd, 2009
Innodb monitors show information about innodb internal status - which could be used for performance tuning. Lets break down the output of show engine innodb status and get a look at what is happening and how it can be improved. Just fire the "Show engine innodb status" command and check the Output.mysql> show engine innodb status\G*************************** 1. row ***************************
PlanetMySQL Voting: Vote UP / Vote DOWN