MySQL 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