# ./mysqlreport -A MySQL 5.0.18-log uptime 0 0:4:54 Tue Dec 12 16:12:00 2006 __ Key _________________________________________________________________ Buffer used 2.49M of 512.00M %Used: 0.49 Current 61.37M %Usage: 11.99 Write ratio 0.001 Read ratio 0.001 __ Questions ___________________________________________________________ Total 12.88k 43.8/s QC Hits 6.45k 21.9/s %Total: 50.09 DMS 3.40k 11.6/s 26.42 Com_ 2.15k 7.3/s 16.74 COM_QUIT 872 3.0/s 6.77 -Unknown 2 0.0/s 0.02 Slow 30 0.1/s 0.23 %DMS: 0.88 DMS 3.40k 11.6/s 26.42 SELECT 3.04k 10.3/s 23.62 89.41 UPDATE 341 1.2/s 2.65 10.03 INSERT 18 0.1/s 0.14 0.53 DELETE 1 0.0/s 0.01 0.03 REPLACE 0 0/s 0.00 0.00 Com_ 2.15k 7.3/s 16.74 change_db 1.51k 5.1/s 11.72 set_option 631 2.1/s 4.90 show_variab 9 0.0/s 0.07 __ SELECT and Sort _____________________________________________________ Scan 605 2.1/s %SELECT: 19.89 Range 14 0.0/s 0.46 Full join 0 0/s 0.00 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 192 0.7/s Sort range 2.22k 7.5/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 1.21M of 256.00M %Used: 0.47 Block Fragmnt 6.56% Hits 6.45k 21.9/s Inserts 2.49k 8.5/s Insrt:Prune 2.49k:1 8.5/s Hit:Insert 2.59:1 __ Table Locks _________________________________________________________ Waited 174 0.6/s %Total: 4.58 Immediate 3.63k 12.3/s __ Tables ______________________________________________________________ Open 50 of 1024 %Cache: 4.88 Opened 56 0.2/s __ Connections _________________________________________________________ Max used 14 of 500 %Max: 2.80 Total 874 3.0/s __ Created Temp ________________________________________________________ Disk table 102 0.3/s Table 108 0.4/s File 5 0.0/s __ Threads _____________________________________________________________ Running 1 of 2 Cached 3 of 4 %Hit: 92.45 Created 66 0.2/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 0 0/s Connects 0 0/s __ Bytes _______________________________________________________________ Sent 27.79M 94.5k/s Received 1.09M 3.7k/s __ InnoDB Buffer Pool __________________________________________________ Usage 304.00k of 8.00M %Used: 3.71 Read ratio 0.156 Pages Free 493 %Total: 96.29 Data 19 3.71 %Drty: 0.00 Misc 0 0.00 Latched 0 0.00 Reads 77 0.3/s From file 12 0.0/s 15.58 Ahead Rnd 1 0.0/s Ahead Sql 0 0/s Writes 0 0/s Flushes 0 0/s Wait Free 0 0/s __ InnoDB Lock _________________________________________________________ Waits 0 0/s Current 0 Time acquiring Total 0 ms Average 0 ms Max 0 ms __ InnoDB Data, Pages, Rows ____________________________________________ Data Reads 25 0.1/s Writes 3 0.0/s fsync 3 0.0/s Pending Reads 0 Writes 0 fysnc 0 Pages Created 0 0/s Read 19 0.1/s Written 0 0/s Rows Deleted 0 0/s Inserted 0 0/s Read 0 0/s Updated 0 0/s