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 <nicolas AT shivaserv DOT fr> 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
------------------------------------------------------------------------------
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
|