Hi, I have this stats: I have tuned some of it but I was wondering if someone can give inputs regarding it:
* __ Key _________________________________________________________________ Buffer used 54.63M of 384.00M %Used: 14.23 Current 123.21M %Usage: 32.09 Write hit 99.97% Read hit 100.00% __ Questions ___________________________________________________________ Total 87.40M 18.4/s QC Hits 50.63M 10.7/s %Total: 57.93 DMS 24.04M 5.1/s 27.50 Com_ 8.52M 1.8/s 9.75 COM_QUIT 4.24M 0.9/s 4.85 -Unknown 28.31k 0.0/s 0.03 Slow 10 s 9.21k 0.0/s 0.01 %DMS: 0.04 Log: OFF DMS 24.04M 5.1/s 27.50 SELECT 21.98M 4.6/s 25.14 91.41 UPDATE 1.74M 0.4/s 1.99 7.24 INSERT 211.35k 0.0/s 0.24 0.88 DELETE 111.77k 0.0/s 0.13 0.46 REPLACE 0 0/s 0.00 0.00 Com_ 8.52M 1.8/s 9.75 set_option 4.26M 0.9/s 4.87 change_db 4.22M 0.9/s 4.83 show_table_ 9.33k 0.0/s 0.01 __ SELECT and Sort _____________________________________________________ Scan 838.37k 0.2/s %SELECT: 3.81 Range 2.12M 0.4/s 9.64 Full join 988 0.0/s 0.00 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 3.71M 0.8/s Sort range 3.63M 0.8/s Sort mrg pass 82.85k 0.0/s __ Query Cache _________________________________________________________ Memory usage 3.75M of 32.00M %Used: 11.72 Block Fragmnt 28.39% Hits 50.63M 10.7/s Inserts 16.38M 3.4/s Insrt:Prune 14.39:1 3.2/s Hit:Insert 3.09:1 __ Table Locks _________________________________________________________ Waited 53.43k 0.0/s %Total: 0.17 Immediate 31.57M 6.6/s __ Tables ______________________________________________________________ Open 512 of 512 %Cache: 100.00 Opened 3.02k 0.0/s __ Connections _________________________________________________________ Max used 145 of 802 %Max: 18.08 Total 4.24M 0.9/s __ Created Temp ________________________________________________________ Disk table 3.61M 0.8/s Table 3.72M 0.8/s Size: 16.0M File 165.71k 0.0/s __ Threads _____________________________________________________________ Running 69 of 71 Cached 0 of 8 %Hit: 99.02 Created 41.74k 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 6.48k 0.0/s Connects 25.00k 0.0/s __ Bytes _______________________________________________________________ Sent 1.18T 247.9k/s Received 15.27G 3.2k/s*
