MySQL 4.0.18 uptime 1 0:26:59 Fri Sep 23 23:14:17 2005 __ Key _________________________________________________________________ Buffer usage 4.29M of 100.00M %Used: 4.29 Write ratio 0.35 Read ratio 0.00 __ Questions ___________________________________________________________ Total 5.96M 67.75/s QC Hits 5.31M 60.37/s %Total: 89.10 DMS 365.83k 4.16/s 6.13 Com_ 156.66k 1.78/s 2.63 COM_QUIT 127.50k 1.45/s 2.14 +Unknown 8 0.00/s 0.00 Slow 10 0.00/s 0.00 %DMS: 0.00 DMS 365.83k 4.16/s 6.13 SELECT 233.13k 2.65/s 3.91 63.73 UPDATE 106.43k 1.21/s 1.78 29.09 INSERT 13.97k 0.16/s 0.23 3.82 DELETE 7.39k 0.08/s 0.12 2.02 REPLACE 4.92k 0.06/s 0.08 1.34 Com_ 156.66k 1.78/s 2.63 change_db 151.77k 1.72/s 2.54 lock_tables 1.31k 0.01/s 0.02 unlock_tabl 1.31k 0.01/s 0.02 __ SELECT and Sort _____________________________________________________ Scan 161.01k 1.83/s %SELECT: 69.07 Range 5.73k 0.07/s 2.46 Full join 3.42k 0.04/s 1.47 Range check 14 0.00/s 0.01 Full rng join 1 0.00/s 0.00 Sort scan 19.93k 0.23/s Sort range 5.47k 0.06/s Sort mrg pass 2 0.00/s __ Query Cache _________________________________________________________ Memory usage 21.43M of 32.00M %Used: 66.98 Block Fragmnt 12.35% Hits 5.31M 60.37/s Inserts 227.83k 2.59/s Prunes 41.98k 0.48/s Insrt:Prune 5.43:1 2.11/s Hit:Insert 23.32:1 __ Table Locks _________________________________________________________ Waited 341 0.00/s %Total: 0.08 Immediate 406.94k 4.62/s __ Tables ______________________________________________________________ Open 593 of 1024 %Cache: 57.91 Opened 2.55k 0.03/s __ Connections _________________________________________________________ Max used 18 of 250 %Max: 7.20 Total 127.57k 1.45/s __ Created Temp ________________________________________________________ Disk table 1.93k 0.02/s Table 7.29k 0.08/s File 4 0.00/s