List:General Discussion« Previous MessageNext Message »
From:J M Date:May 6 2011 11:26am
Subject:Re: Input needed...
View as plain text  
Config:

Running on 8G Server.. Currently utilizing 7G.. running only mysql..

[client]
port            = 3306
socket          = /var/lib/mysql/mysql.sock


[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
max_connections = 802
wait_timeout = 15


log-bin=mysql-bin

server-id       = 1



innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

On Thu, May 5, 2011 at 2:46 PM, Reindl Harald <h.reindl@stripped>wrote:

> 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
>
>

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