MYSQL data process error: "The total number of locks exceeds the lock table size"

To solve the problem, please add below line  under the [mysqld] in /etc/my.cnf file. I have used

 innodb_buffer_pool_size=4256M

After that we have to execute the command from root user.

#service mysqld restart