Skip to content


mysqlreport 查看mysql状态

mysqlreport以非常友好的方式显示MySQL状态变量值。和SHOW STATUS不同,mysqlreport以一种非常格式化的方式输出状态值,具有非常好的可读性。

wget http://hackmysql.com/scripts/mysqlreport-3.5.tgz tar zxvf mysqlreport-3.5.tgz cd mysqlreport-3.5 chmod +x mysqlreport ./mysqlreport

Use of uninitialized value in subtraction (-) at ./mysqlreport line 648. Use of uninitialized value in subtraction (-) at ./mysqlreport line 648. Use of uninitialized value in multiplication (*) at ./mysqlreport line 648. Use of uninitialized value in multiplication (*) at ./mysqlreport line 652. Use of uninitialized value in multiplication (*) at ./mysqlreport line 652. MySQL 5.1.26-rc uptime 0 2:57:2 Wed Nov 17 14:48:32 2010 __ Key _________________________________________________________________ Buffer used 366.25M of 3.02G %Used: 11.83 Current 944.89M %Usage: 30.52 Write hit 52.83% Read hit 99.95% __ Questions ___________________________________________________________ Total 6.76M 636.3/s DMS 3.34M 314.0/s %Total: 49.35 Com_ 1.92M 180.5/s 28.36 COM_QUIT 823.41k 77.5/s 12.18 QC Hits 684.24k 64.4/s 10.12 -Unknown 978 0.1/s 0.01 Slow 10 s 83 0.0/s 0.00 %DMS: 0.00 Log: OFF DMS 3.34M 314.0/s 49.35 SELECT 2.47M 232.2/s 36.49 73.94 UPDATE 360.06k 33.9/s 5.33 10.80 INSERT 238.60k 22.5/s 3.53 7.15 DELETE 172.46k 16.2/s 2.55 5.17 REPLACE 97.91k 9.2/s 1.45 2.94 Com_ 1.92M 180.5/s 28.36 set_option 1.12M 105.5/s 16.57 change_db 743.18k 70.0/s 11.00 show_variab 26.44k 2.5/s 0.39 __ SELECT and Sort _____________________________________________________ Scan 90.27k 8.5/s %SELECT: 3.66 Range 94.02k 8.9/s 3.81 Full join 35 0.0/s 0.00 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 59.49k 5.6/s Sort range 136.07k 12.8/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 50.50M of 128.00M %Used: 39.45 Block Fragmnt 24.56% Hits 684.24k 64.4/s Inserts 2.39M 224.6/s Insrt:Prune 2.39M:1 224.6/s Hit:Insert 0.29:1 __ Table Locks _________________________________________________________ Waited 156.42k 14.7/s %Total: 3.20 Immediate 4.73M 445.4/s __ Tables ______________________________________________________________ Open 1238 of 3072 %Cache: 40.30 Opened 2.27k 0.2/s __ Connections _________________________________________________________ Max used 111 of 350 %Max: 31.71 Total 824.31k 77.6/s __ Created Temp ________________________________________________________ Disk table 29.99k 2.8/s Table 100.82k 9.5/s Size: 1.0G File 0 0/s __ Threads _____________________________________________________________ Running 2 of 4 Cached 76 of 80 %Hit: 99.97 Created 208 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 1.78k 0.2/s Connects 42 0.0/s __ Bytes _______________________________________________________________ Sent 13.50G 1.3M/s Received 1.08G 101.5k/s

mysql配置信息参照之前的优化 https://blog.c1gstudio.com/archives/1142

Posted in Mysql, 技术.

Tagged with , .


No Responses (yet)

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.