Skip navigation links

MySQL Forums :: Performance :: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations


Advanced Search

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
my.cnf for MySQL 5.5 on CentOS 5.5 recomandations 11463 Roni Alboim 02/01/2011 09:58AM
Re: my.cnf for MySQL 5.5 on CentOS 5.5 recomandations 2954 Rick James 02/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.