Innodb data writes PS(writes/Uptime) : 9.54/s (65.89M/6.91M) 6.12/s (367.00/60.00)
Innodb data fsyncs PS(fsyncs/Uptime) : 1.15/s (7.91M/6.91M) 0.87/s (52.00/60.00)
Innodb data pending reads PS(reads/Uptime): 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
Innodb data pending writes PS(write/Uptime): 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
Innodb data pending fsyncs PS(fsync/Uptime): 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
------------------------------------
key buffer Status
------------------------------------
key buffer used ratio(used/size) : 0.05% (185.00k/384.00M) Lower than 99.99
key buffer read hit ratio(reads/request) : 100.00% (183.00/208.97M) 100.00% (0.00/0.00) Higher than 99.99
key buffer write hit ratio(writes/request): 81.37% (8.95M/48.03M) 100.00% (0.00/0.00) Higher than 99.99
------------------------------------
Qcache Status
------------------------------------
Qcache hits inserts ratio(hits/inserts) : 1.59k% (609.41M/37.40M) 101.32% (77.00/76.00) Higher than 300.00
Qcache memory used ratio(free/total) : 54.62% (7.26M/16.00M)
Qcache prune ratio(prunes/inserts) : 5.31% (1.99M/37.40M) 0.00% (0.00/76.00)
Qcache block Fragmnt ratio(free/total) : 23.65% (2.75k/11.63k)
------------------------------------
Slave Status
------------------------------------
Slave running status : OFF OFF
Slave open temp tables : 0.00 0.00
Slave transactions PS(transactions/Uptime): 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
Slave received PS(heartbeats/Uptime) : 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
脚本附件下载
具体下载目录在 /2012年资料/8月/10日/MySQL数据库各项性能详细参数查看脚本/