rendered paste bodyMySQL 5.0.24-community uptime 16 22:43:57 Mon Oct 2 11:56:31 2006
__ Key _________________________________________________________________
Buffer used 14.00k of 16.00k %Used: 87.50
Current 15.00k %Usage: 93.75
Write ratio 0.62
Read ratio 0.14
__ Questions ___________________________________________________________
Total 54.85M 37.46/s
DMS 54.17M 36.99/s %Total: 98.75
QC Hits 307.01k 0.21/s 0.56
Com_ 233.38k 0.16/s 0.43
COM_QUIT 158.19k 0.11/s 0.29
-Unknown 10.69k 0.01/s 0.02
Slow 38 0.00/s 0.00 %DMS: 0.00
DMS 54.17M 36.99/s 98.75
SELECT 26.71M 18.24/s 48.70 49.32
INSERT 22.95M 15.67/s 41.83 42.36
DELETE 4.22M 2.88/s 7.70 7.79
UPDATE 283.23k 0.19/s 0.52 0.52
REPLACE 1.44k 0.00/s 0.00 0.00
Com_ 233.38k 0.16/s 0.43
change_db 158.62k 0.11/s 0.29
set_option 47.57k 0.03/s 0.09
admin_comma 13.13k 0.01/s 0.02
truncate 3.00k 0.00/s 0.01
drop_index 2.83k 0.00/s 0.01
create_inde 2.83k 0.00/s 0.01
show_tables 1.07k 0.00/s 0.00
show_create 765 0.00/s 0.00
show_fields 757 0.00/s 0.00
create_tabl 431 0.00/s 0.00
__ SELECT and Sort _____________________________________________________
Scan 737.19k 0.50/s %SELECT: 2.76
Range 170.99k 0.12/s 0.64
Full join 68 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 174.78k 0.12/s
Sort range 154.64k 0.11/s
Sort mrg pass 842 0.00/s
__ Query Cache _________________________________________________________
Memory usage 77.66M of 300.00M %Used: 25.89
Block Fragmnt 17.39%
Hits 307.01k 0.21/s
Inserts 628.32k 0.43/s
Prunes 1 0.00/s
Insrt:Prune 628.32k:1 0.43/s
Hit:Insert 0.49:1
__ Table Locks _________________________________________________________
Waited 172 0.00/s %Total: 0.00
Immediate 53.53M 36.55/s
__ Tables ______________________________________________________________
Open 4 of 4 %Cache: 100.00
Opened 8.73M 5.96/s
__ Connections _________________________________________________________
Max used 17 of 100 %Max: 17.00
Total 160.57k 0.11/s
__ Created Temp ________________________________________________________
Disk table 2.28k 0.00/s
Table 39.95k 0.03/s
File 1.20k 0.00/s
__ Threads _____________________________________________________________
Running 1 of 6
Cached 0 of 0 %Hit: 0
Created 160.57k 0.11/s
Slow 0 0.00/s
__ Aborted _____________________________________________________________
Clients 4.75k 0.00/s
Connects 143 0.00/s
__ Bytes _______________________________________________________________
Sent 714.77M 488.15/s
Received 4.07G 2.78k/s