mysqlreport Live Demonstration
MySQL 5.1.55-rel12.6 uptime 150 1:26:30 Fri Feb 3 17:52:27 2012
__ Key _________________________________________________________________
Buffer used 31.71M of 128.00M %Used: 24.78
Current 33.79M %Usage: 26.40
Write hit 86.84%
Read hit 99.48%
__ Questions ___________________________________________________________
Total 1.02G 78.5/s
QC Hits 547.52M 42.2/s %Total: 53.77
DMS 270.73M 20.9/s 26.59
Com_ 172.17M 13.3/s 16.91
COM_QUIT 36.80M 2.8/s 3.61
-Unknown 8.91M 0.7/s 0.88
Slow 30.64k 0.0/s 0.00 %DMS: 0.01
DMS 270.73M 20.9/s 26.59
SELECT 230.33M 17.8/s 22.62 85.08
UPDATE 26.08M 2.0/s 2.56 9.63
INSERT 8.64M 0.7/s 0.85 3.19
DELETE 5.53M 0.4/s 0.54 2.04
REPLACE 151.91k 0.0/s 0.01 0.06
Com_ 172.17M 13.3/s 16.91
change_db 56.37M 4.3/s 5.54
set_option 40.04M 3.1/s 3.93
show_fields 17.00M 1.3/s 1.67
__ SELECT and Sort _____________________________________________________
Scan 74.66M 5.8/s %SELECT: 32.42
Range 15.23M 1.2/s 6.61
Full join 776.51k 0.1/s 0.34
Range check 44.75k 0.0/s 0.02
Full rng join 26.95k 0.0/s 0.01
Sort scan 15.77M 1.2/s
Sort range 16.60M 1.3/s
Sort mrg pass 250.64k 0.0/s
__ Query Cache _________________________________________________________
Memory usage 211.71M of 256.00M %Used: 82.70
Block Fragmnt 11.52%
Hits 547.52M 42.2/s
Inserts 200.75M 15.5/s
Insrt:Prune 3.31:1 10.8/s
Hit:Insert 2.73:1
__ Table Locks _________________________________________________________
Waited 369.93k 0.0/s %Total: 0.12
Immediate 308.61M 23.8/s
__ Tables ______________________________________________________________
Open 1024 of 1024 %Cache: 100.00
Opened 24.17M 1.9/s
__ Connections _________________________________________________________
Max used 501 of 500 %Max: 100.20
Total 36.81M 2.8/s
__ Created Temp ________________________________________________________
Disk table 27.30M 2.1/s
Table 61.45M 4.7/s
File 244.74k 0.0/s
__ Threads _____________________________________________________________
Running 1 of 6
Cached 45 of 50 %Hit: 100
Created 1.72k 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 16.18k 0.0/s
Connects 383.74k 0.0/s
__ Bytes _______________________________________________________________
Sent 10.44T 805.2k/s
Received 226.62G 17.5k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 383.95M of 383.98M %Used: 99.99
Read ratio 0.001
Pages
Free 2 %Total: 0.01
Data 24.02k 97.73 %Drty: 0.00
Misc 557 2.27
Latched 0.00
Reads 3.02G 232.5/s
From file 2.31M 0.2/s 0.08
Ahead Rnd 0/s
Ahead Sql 0/s
Writes 154.53M 11.9/s
Flushes 4.48M 0.3/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 688 0.0/s
Current 0
Time acquiring
Total 3631461 ms
Average 5278 ms
Max 121843 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 2.38M 0.2/s
Writes 7.55M 0.6/s
fsync 3.21M 0.2/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 208.58k 0.0/s
Read 3.97M 0.3/s
Written 4.48M 0.3/s
Rows
Deleted 11.54M 0.9/s
Inserted 19.57M 1.5/s
Read 1.15G 89.0/s
Updated 1.69M 0.1/s