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]
Links:
------
[1] mailto:nico...@shivaserv.fr
[2]
http://www.shivaserv.fr
------------------------------------------------------------------------------
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
