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*
