please post your my.cnf settings becuase stats are useless without knowing the configuration and without knowing your hardware (memory!) nobody can say what buffers are making sense
i would use "mysqltuner.pl" because it shows in the most cases good advises Am 05.05.2011 20:42, schrieb J M: > 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* > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
