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: jerom...@gmail.com > To: h.rei...@thelounge.net > CC: mysql@lists.mysql.com > > 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.rei...@thelounge.net>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 > > > >
