Wednesday 11 January 2012

InnoDB-Buffer Pool Size

1. We have to check RAM and ,  You can set .._buffer_pool_size up to 50 - 80 %  of RAM but beware of setting memory usage too high

Posted by at
Labels:

1 comment:

  1. jayaram12 January 2012 at 02:12

    And you can set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 64M.

    To apply above settings to mysql-servers, first have to delete innodb_log file and restart the mysql-server.

    ReplyDelete

Subscribe to: Post Comments (Atom)