mysqlreport Live Demonstration
MySQL 5.1.55-rel12.6 uptime 23 3:57:31 Thu May 17 00:29:28 2012
__ Key _________________________________________________________________
Buffer used 54.32M of 128.00M %Used: 42.44
Current 47.14M %Usage: 36.82
Write hit 84.37%
Read hit 98.98%
__ Questions ___________________________________________________________
Total 198.43M 99.1/s
QC Hits 111.64M 55.8/s %Total: 56.26
DMS 47.63M 23.8/s 24.00
Com_ 33.67M 16.8/s 16.97
COM_QUIT 6.79M 3.4/s 3.42
-Unknown 1.29M 0.6/s 0.65
Slow 18.03k 0.0/s 0.01 %DMS: 0.04
DMS 47.63M 23.8/s 24.00
SELECT 38.66M 19.3/s 19.48 81.16
UPDATE 4.92M 2.5/s 2.48 10.33
INSERT 2.55M 1.3/s 1.29 5.36
DELETE 1.44M 0.7/s 0.73 3.02
REPLACE 57.02k 0.0/s 0.03 0.12
Com_ 33.67M 16.8/s 16.97
set_option 9.53M 4.8/s 4.80
change_db 8.53M 4.3/s 4.30
show_fields 3.35M 1.7/s 1.69
__ SELECT and Sort _____________________________________________________
Scan 13.68M 6.8/s %SELECT: 35.38
Range 4.09M 2.0/s 10.57
Full join 208.17k 0.1/s 0.54
Range check 5.73k 0.0/s 0.01
Full rng join 18.40k 0.0/s 0.05
Sort scan 2.77M 1.4/s
Sort range 2.38M 1.2/s
Sort mrg pass 30.29k 0.0/s
__ Query Cache _________________________________________________________
Memory usage 207.76M of 256.00M %Used: 81.16
Block Fragmnt 13.81%
Hits 111.64M 55.8/s
Inserts 31.45M 15.7/s
Insrt:Prune 2.94:1 10.4/s
Hit:Insert 3.55:1
__ Table Locks _________________________________________________________
Waited 41.33k 0.0/s %Total: 0.08
Immediate 54.51M 27.2/s
__ Tables ______________________________________________________________
Open 1024 of 1024 %Cache: 100.00
Opened 5.70M 2.8/s
__ Connections _________________________________________________________
Max used 186 of 500 %Max: 37.20
Total 6.79M 3.4/s
__ Created Temp ________________________________________________________
Disk table 5.18M 2.6/s
Table 11.17M 5.6/s
File 60.21k 0.0/s
__ Threads _____________________________________________________________
Running 15 of 27
Cached 40 of 50 %Hit: 99.98
Created 1.29k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 1.99k 0.0/s
Connects 19.16k 0.0/s
__ Bytes _______________________________________________________________
Sent 1.83T 916.2k/s
Received 46.97G 23.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 383.22M of 383.98M %Used: 99.80
Read ratio 0.002
Pages
Free 49 %Total: 0.20
Data 23.69k 96.39 %Drty: 26.54
Misc 838 3.41
Latched 0.00
Reads 1.21G 603.3/s
From file 2.74M 1.4/s 0.23
Ahead Rnd 0/s
Ahead Sql 0/s
Writes 50.21M 25.1/s
Flushes 3.20M 1.6/s
Wait Free 29 0.0/s
__ InnoDB Lock _________________________________________________________
Waits 2785 0.0/s
Current 0
Time acquiring
Total 1753633 ms
Average 629 ms
Max 121131 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 2.81M 1.4/s
Writes 4.09M 2.0/s
fsync 1.50M 0.8/s
Pending
Reads 0
Writes 0
fsync 4
Pages
Created 142.19k 0.1/s
Read 3.64M 1.8/s
Written 3.20M 1.6/s
Rows
Deleted 2.25M 1.1/s
Inserted 4.53M 2.3/s
Read 859.10M 429.2/s
Updated 927.14k 0.5/s