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配置信息参照之前的优化
http://blog.c1gstudio.com/archives/1142