Re: Max size of innodb_buffer_pool_size
Posted by: Rick James
Date: June 21, 2010 09:10AM

Set innodb_buffer_pool_size to 70% of _available_ RAM if you are using InnoDB entirely (and little or no MyISAM).

32-bit OS will restrict each program (eg mysqld) to 3GB or maybe 2GB.

If the server is running only MySQL, then 70% of RAM. If you are running a bunch of other things, then compensate for them.

If innodb_buffer_pool_size is set "too high", the OS will start "swapping". This is more detrimental than setting innodb_buffer_pool_size smaller.

Options: ReplyQuote

Written By
Re: Max size of innodb_buffer_pool_size
June 21, 2010 09:10AM

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.