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