This issue can be resolved by setting the higher values for the MySQL variable “innodb_buffer_pool_size”. The default value for innodb_buffer_pool_size will be 8,388,608.
To change the settings value for “innodb_buffer_pool_size” please see the below set.
1) Locate the file my.cnf from the server. For Linus servers this will be mostly at /etc/my.cnf
2) Add the line “innodb_buffer_pool_size=64MB” to this file
3) Restart the MySQL server
To restart the MySQL server, you can use anyone of the below 2 options:
1) service mysqld restart
2) /etc/init.d/mysqld restart
Related articles
- MySQL Tips For WordPress That Don’t Suck (bostinno.com)
- Troubleshooting MySQL Memory Usage (mysqlperformanceblog.com)
- Fixing MySQL tables in Fedora 17 (morefedora.blogspot.com)
