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.
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.