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.
Subject
Views
Written By
Posted
17232
April 29, 2009 12:40AM
Re: Memory settings for server with 4GB RAM
9820
April 29, 2009 09:14AM
7038
April 29, 2009 06:07PM
7877
April 30, 2009 08:55AM
6511
May 01, 2009 01:43PM
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.