转载: http://www.linuxtone.org/html/45/t-3645.html
其中有一段狗屁不通的英语为本人原创,但愿看官能看的明白
show SLAVE status
This statement provides status information on essential parameters of the slave threads. It requires either the SUPER or REPLICATION CLIENT privilege.
If you issue this statement using the mysql client, you can use a \G statement terminator rat...
show INNODB status walk through
In show INNODB status many values are per second. If you're planning to use these values make sure they are sampled over decent period of time. In the very start of printout Innodb will print:
在 show INNODB status 中许多值都是按秒统计的,如果要使用这些值,就得隔适当的时间取样。show INNODB status 的开头应该是:
=====================================
060717 3:07:56 ...