mysql performance report 开启,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