|
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 [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)
------------------------------------------------------------------------------
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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
