InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks.

Today one of my friend reported error message in one of his MySQL 5.6.35 Community Version.

InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks.

InnoDB: Your buffer pool size is 127 MB. Maybe you should make the buffer pool bigger?

InnoDB: Starting the InnoDB Monitor to print diagnostics, including lock heap and hash index sizes.

Solution:

This warning message mostly occur when the assigned “innodb-buffer-pool” size exceed the limit. Ideally you have to assign at least 70 to 80 percent of system memory to buffer pool. Also check the transactions wether it is a Sequential or Random transaction.

 

To resolve the issue you need to increase the value of “innodb-buffer-pool-size” in the “my.cnf” file and restart the mysql service.

 

Monitor the MySQL performance for a time and check the log file wether the error is coming or not.

 

 

WP2Social Auto Publish Powered By : XYZScripts.com