Re: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations
Posted by:
Rick James
Date: February 03, 2011 12:46AM
long_query_time = 100 --> 2 -- this will give you some chance of catching naughty queries.
Will you be using MyISAM or InnoDB? Decide, then read
http://mysql.rjweb.org/doc.php/memory
for cache settings.
Some debate here?
innodb_flush_log_at_trx_commit = 2 # Roni: 1
1 is "safer", 2 is "faster".
innodb_log_file_size = 1G # Roni: 256M
I agree with 1G, based on your large RAM.
That's a lot of iron for "few batch jobs once a day".
Subject
Views
Written By
Posted
13776
February 01, 2011 09:58AM
Re: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations
4083
February 03, 2011 12:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.