From: Martin Gainty Date: May 6 2011 11:38am Subject: RE: Input needed... List-Archive: http://lists.mysql.com/mysql/224962 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_6514b32e-34b7-4a3f-9e2d-304817265815_" --_6514b32e-34b7-4a3f-9e2d-304817265815_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Harald- could you re-iterate the details of the malady or error you are experiencin= g? danke=2C Martin=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. > Date: Fri=2C 6 May 2011 07:26:20 -0400 > Subject: Re: Input needed... > From: jerome.m@stripped > To: h.reindl@stripped > CC: mysql@stripped >=20 > Config: >=20 > Running on 8G Server.. Currently utilizing 7G.. running only mysql.. >=20 > [client] > port =3D 3306 > socket =3D /var/lib/mysql/mysql.sock >=20 >=20 > [mysqld] > port =3D 3306 > socket =3D /var/lib/mysql/mysql.sock > skip-locking > key_buffer_size =3D 384M > max_allowed_packet =3D 1M > table_open_cache =3D 512 > sort_buffer_size =3D 2M > read_buffer_size =3D 2M > read_rnd_buffer_size =3D 8M > myisam_sort_buffer_size =3D 64M > thread_cache_size =3D 8 > query_cache_size =3D 32M > thread_concurrency =3D 8 > max_connections =3D 802 > wait_timeout =3D 15 >=20 >=20 > log-bin=3Dmysql-bin >=20 > server-id =3D 1 >=20 >=20 >=20 > innodb_data_home_dir =3D /var/lib/mysql/ > innodb_data_file_path =3D ibdata1:2000M=3Bibdata2:10M:autoextend > innodb_log_group_home_dir =3D /var/lib/mysql/ > innodb_buffer_pool_size =3D 384M > innodb_additional_mem_pool_size =3D 20M > innodb_log_file_size =3D 100M > innodb_log_buffer_size =3D 8M > innodb_flush_log_at_trx_commit =3D 1 > innodb_lock_wait_timeout =3D 50 >=20 > [mysqldump] > quick > max_allowed_packet =3D 16M >=20 > [mysql] > no-auto-rehash >=20 > [myisamchk] > key_buffer_size =3D 256M > sort_buffer_size =3D 256M > read_buffer =3D 2M > write_buffer =3D 2M >=20 > [mysqlhotcopy] > interactive-timeout >=20 > On Thu=2C May 5=2C 2011 at 2:46 PM=2C Reindl Harald wrote: >=20 > > 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=2C schrieb J M: > > > Hi=2C > > > > > > 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: O= FF > > > 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=FC=DFen=2C Reindl Harald > > the lounge interactive design GmbH > > A-1060 Vienna=2C Hofm=FChlgasse 17 > > CTO / software-development / cms-solutions > > p: +43 (1) 595 3999 33=2C m: +43 (676) 40 221 40 > > icq: 154546673=2C http://www.thelounge.net/ > > > > http://www.thelounge.net/signature.asc.what.htm > > > > = --_6514b32e-34b7-4a3f-9e2d-304817265815_--