Hi, tuning-primer send me some infos, I'll try this night some parameters to see :)
thanks Nicolas http://www.shivaserv.fr Le 27 mars 2012 à 16:23, Jérôme Blion <jerome.bl...@free.fr> a écrit : > 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 ------------------------------------------------------------------------------ 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
