MySQL 0.0.0 uptime 1 12:59:52 Fri Sep 23 23:14:47 2005 __ Key _________________________________________________________________ Buffer usage 15.22M of 16.00M %Used: 95.13 Write ratio 0.88 Read ratio 0.00 __ Questions ___________________________________________________________ Total 2.67M 20.06/s DMS 1.43M 10.76/s %Total: 53.62 QC Hits 908.93k 6.82/s 34.02 Com_ 165.52k 1.24/s 6.19 COM_QUIT 164.85k 1.24/s 6.17 -Unknown 1 0.00/s 0.00 Slow 72 0.00/s 0.00 %DMS: 0.01 DMS 1.43M 10.76/s 53.62 SELECT 992.81k 7.45/s 37.16 69.30 UPDATE 316.50k 2.38/s 11.85 22.09 INSERT 104.86k 0.79/s 3.92 7.32 DELETE 11.95k 0.09/s 0.45 0.83 REPLACE 6.55k 0.05/s 0.25 0.46 Com_ 165.52k 1.24/s 6.19 change_db 164.85k 1.24/s 6.17 show_tables 168 0.00/s 0.01 show_fields 166 0.00/s 0.01 __ SELECT and Sort _____________________________________________________ Scan 120.61k 0.91/s %SELECT: 12.15 Range 287.89k 2.16/s 29.00 Full join 31 0.00/s 0.00 Range check 0 0.00/s 0.00 Full rng join 26 0.00/s 0.00 Sort scan 63.26k 0.47/s Sort range 212.59k 1.60/s Sort mrg pass 0 0.00/s __ Query Cache _________________________________________________________ Memory usage 15.41M of 64.00M %Used: 24.08 Block Fragmnt 16.33% Hits 908.93k 6.82/s Inserts 992.01k 7.45/s Prunes 1 0.00/s Insrt:Prune 992.01k:1 7.45/s Hit:Insert 0.92:1 __ Table Locks _________________________________________________________ Waited 4.73k 0.04/s %Total: 0.16 Immediate 2.90M 21.79/s __ Tables ______________________________________________________________ Open 768 of 1024 %Cache: 75.00 Opened 774 0.01/s __ Connections _________________________________________________________ Max used 132 of 300 %Max: 44.00 Total 164.86k 1.24/s __ Created Temp ________________________________________________________ Disk table 421 0.00/s Table 66.72k 0.50/s File 0 0.00/s