MySQL Forums
Forum List  »  Performance

Re: Memory settings for server with 4GB RAM
Posted by: Aftab Khan
Date: April 29, 2009 09:14AM

Myisam/Innodb?

for myisam set key_buffer= 20%-25% of the RAM

for innodb
set innodb_buffer_pool_size= on dedicated servers it can be 50%-80% of the RAM.
innodb_log_file_size=25%-100% of the innodb_buffer_pool_size, note The larger the value, the less checkpoint flush activity is needed in the buffer pool, saving disk I/O. But larger log files also mean that recovery is slower in case of a crash.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Memory settings for server with 4GB RAM
9820
April 29, 2009 09:14AM


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.