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