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
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
