The total number of locks exceeds the lock table size

by

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

Reference The total number of locks exceeds the lock table size

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. Rank function in MySQL
  3. MySQL select 10 random rows from 600K rows fast
  4. Get a list of dates between two dates
  5. Count the number of occurrences of a string in a VARCHAR field?
  6. Find nearest latitude/longitude with an SQL query
  7. Simulate lag function in MySQL
  8. Get record counts for all tables in MySQL database
  9. Most efficient way to get table row count
  10. How do I check if a column is empty or null in MySQL?
  11. Use MySQL spatial extensions to select points inside circle
  12. Subqueries with EXISTS vs IN – MySQL
  13. What is this operator in MySQL?
  14. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  15. MySQL Workbench: How to keep the connection alive
  16. Filter by COUNT(*)?
  17. Deleting duplicate rows from a table
  18. MySQL concatenation operator
  19. SQL Group By with an Order By
  20. How create json format with group-concat mysql?
  21. MySQL LIKE query with underscore
  22. MySql – Way to update portion of a string?
  23. Using reserved words in column names
  24. MySQL INNER JOIN select only one row from second table
  25. Storing IPv6 Addresses in MySQL
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. INSERT INTO Table from multiple tables
  29. Execute INSERT if table is empty?
  30. Mysql How do you create a clustered index?

Leave a Comment