MySQL 4.1.13 uptime 0 22:4:26 Fri Sep 23 23:12:01 2005 __ Key _________________________________________________________________ Buffer usage 15.11M of 2.00G %Used: 0.74 Write ratio 0.68 Read ratio 0.00 __ Questions ___________________________________________________________ Total 3.30M 41.56/s Com_ 1.71M 21.49/s %Total: 51.71 QC Hits 648.44k 8.16/s 19.64 +Unknown 566.23k 7.13/s 17.15 DMS 228.52k 2.88/s 6.92 COM_QUIT 151.38k 1.90/s 4.58 Slow 1.74k 0.02/s 0.05 %DMS: 0.76 DMS 228.52k 2.88/s 6.92 SELECT 198.94k 2.50/s 6.02 87.06 INSERT 13.27k 0.17/s 0.40 5.81 UPDATE 12.88k 0.16/s 0.39 5.64 DELETE 3.43k 0.04/s 0.10 1.50 REPLACE 0 0.00/s 0.00 0.00 Com_ 1.71M 21.49/s 51.71 change_db 1.70M 21.35/s 51.38 set_option 5.47k 0.07/s 0.17 commit 2.74k 0.03/s 0.08 __ SELECT and Sort _____________________________________________________ Scan 117 0.00/s %SELECT: 0.06 Range 50.45k 0.63/s 25.36 Full join 0 0.00/s 0.00 Range check 0 0.00/s 0.00 Full rng join 0 0.00/s 0.00 Sort scan 44.97k 0.57/s Sort range 43.09k 0.54/s Sort mrg pass 0 0.00/s __ Query Cache _________________________________________________________ Memory usage 1.19M of 32.00M %Used: 3.72 Block Fragmnt 19.87% Hits 648.44k 8.16/s Inserts 184.80k 2.33/s Prunes 1 0.00/s Insrt:Prune 184.80k:1 2.33/s Hit:Insert 3.51:1 __ Table Locks _________________________________________________________ Waited 40.53k 0.51/s %Total: 14.74 Immediate 234.38k 2.95/s __ Tables ______________________________________________________________ Open 195 of 2457 %Cache: 0.79 Opened 196 0.00/s __ Connections _________________________________________________________ Max used 101 of 1638 %Max: 0.62 Total 151.42k 1.91/s __ Created Temp ________________________________________________________ Disk table 44.87k 0.56/s Table 44.86k 0.56/s File 0 0.00/s