List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 5 2011 6:46pm
Subject:Re: Input needed...
View as plain text  
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
Thread
Input needed...J M5 May
  • Re: Input needed...Reindl Harald5 May
    • Re: Input needed...J M6 May
      • RE: Input needed...Martin Gainty6 May
      • Re: Input needed...Reindl Harald6 May
        • RE: Input needed...Martin Gainty6 May
        • Re: Input needed...Peter Boros8 May