MySQL 4.0.18-standa uptime 1 0:29:43 Wed Aug 10 15:18:48 EDT 2005 __ Key _________________________________________________________________ Buffer usage 4.29M of 100.00M %Used: 4.29 Write ratio 0.35 Read ratio 0.00 __ Questions ___________________________________________________________ Total 5.97M 67.67/s Slow 10 0.00/s %Total: 0.00 %DMS: 0.00 DMS 366.37k 4.15/s 6.14 SELECT 233.46k 2.65/s 3.91 63.72 UPDATE 106.61k 1.21/s 1.79 29.10 INSERT 13.98k 0.16/s 0.23 3.82 DELETE 7.40k 0.08/s 0.12 2.02 REPLACE 4.92k 0.06/s 0.08 1.34 Com_ 156.90k 1.78/s 2.63 change_db 152.00k 1.72/s 2.55 lock_tables 1.31k 0.01/s 0.02 unlock_tabl 1.31k 0.01/s 0.02 __ SELECT and Sort _____________________________________________________ Scan 161.22k 1.83/s %SELECT: 69.06 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.94k 0.23/s Sort range 5.47k 0.06/s Sort mrg pass 2 0.00/s __ Query Cache _________________________________________________________ Memory usage 21.42M of 32.00M %Used: 66.93 Block Fragmnt 12.41% Hits 5.32M 60.28/s Inserts 228.16k 2.59/s Prunes 42.00k 0.48/s Insert:Prune 5.43:1 2.11/s Hit:Insert 23.30:1 __ Table Locks _________________________________________________________ Waited 341 0.00/s %Total: 0.08 Immediate 407.56k 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.80k 1.45/s __ Created Temp ________________________________________________________ Disk table 1.93k 0.02/s Table 7.30k 0.08/s File 4 0.00/s