On Tue, 27 Mar 2012 13:10:02 +0200, Nicolas wrote: > I tried, but no changes.. > > Mysqltuner give it for "performance" : > > -------- Performance Metrics > ------------------------------------------------- > [--] Up for: 2h 40m 21s (171K q [17.787 qps], 23 conn, TX: 31M, RX: > 22M) > [--] Reads / Writes: 0% / 100% > [--] Total buffers: 572.0M global + 2.7M per thread (151 max threads) > [OK] Maximum possible memory usage: 987.2M (49% of installed RAM) > [OK] Slow queries: 0% (1/171K) > [OK] Highest usage of available connections: 1% (2/151) > [OK] Key buffer size / total MyISAM indexes: 256.0M/130.9M > [OK] Key buffer hit rate: 99.3% (2M cached / 16K reads) > [OK] Query cache efficiency: 56.9% (95 cached / 167 selects) > [OK] Query cache prunes per day: 0 > [OK] Sorts requiring temporary tables: 9% (2 temp sorts / 21 sorts) > [!!] Temporary tables created on disk: 28% (11 on disk / 38 total) > [OK] Thread cache hit rate: 91% (2 created / 23 connections) > [OK] Table cache hit rate: 74% (52 open / 70 opened) > [OK] Open file limit used: 8% (99/1K) > [OK] Table locks acquired immediately: 100% (237 immediate / 237 > locks) > [!!] Connections aborted: 8% > > On Tue, 27 Mar 2012 11:55:41 +0200, Jérôme Blion wrote: > >> On Tue, 27 Mar 2012 10:28:01 +0200, Nicolas wrote: >> >>> Oups, I made a mistake on my conf, parameters are not on >>> [mysqld]... On Tue, 27 Mar 2012 09:45:54 +0200, Nicolas wrote: >>> >>>> Hi, I try to optimize mysql with some infos find on the web, but >>>> that not better :s For the backup, it take 11 min to save datas, >>>> but 1 hour to update mysql table... My my.cnf : [mysqld] >>>> datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock >>>> user=mysql # Disabling symbolic-links is recommended to prevent >>>> assorted security risks symbolic-links=0 [mysqld_safe] >>>> log-error=/var/log/mysqld.log >>>> pid-file=/var/run/mysqld/mysqld.pid query_cache_size=32M >>>> tmp_table_size=256M max_heap_table_size=256M thread_cache_size=4 >>>> table_cache=512 key_buffer_size=256M On Mon, 26 Mar 2012 >>>> 12:13:28 -0400, John Drescher wrote: >>>> >>>>> On Mon, Mar 26, 2012 at 12:09 PM, Nicolas wrote: >>>>> >>>>>> good idea ! i'll try it asap and let you know. >>>>> Also its best if you can have the database on a different >>>>> raid than the storage or put the database on an SSD. John M. >>>>> Drescher >>>> -- Nicolas http://www.shivaserv.fr [1] [2] >> >> Hello, >> >> Each database server is different. >> If you want to perform some tuning, you can help yourself with >> tuning-primer.sh + mysqltuner.pl. >> They provide good metrics to start with. If you are facing table >> locking issue, perhaps you should migrate to InnoDB (if you use >> Mysql >> 5.1, use the InnoDB Plugin, not the embedded one) >> >> HTH. >> Jérôme Blion (Lyon, France)
Hello, Please don't obfuscate anything. tuning-primer provides more metrics data. Best regards. Jerome Blion. ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
