rendered paste body# ./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