MySQL Forums
Forum List  »  Performance

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".

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations
3750
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.