List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:May 6 2011 11:38am
Subject:RE: Input needed...
View as plain text  
Harald-

could you re-iterate the details of the malady or error you are experiencing?

danke,
Martin 
______________________________________________ 
Verzicht und Vertraulichkeitanmerkung
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so
bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer
Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.






> Date: Fri, 6 May 2011 07:26:20 -0400
> Subject: Re: Input needed...
> From: jerome.m@stripped
> To: h.reindl@stripped
> CC: mysql@stripped
> 
> 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