MySQL Error

[chocho63]

I've got this error while deleting items from Zabbix :

SQL error: The total number of locks exceeds the lock table size
Query: delete from history where itemid=17410
SQL error: The total number of locks exceeds the lock table size
Query: delete from history where itemid=17411

Can I extend this number of locks ?

Deleting items with all history is very long.

[chocho63]

Solution

I've found the solution :

change in my.cnf the following variable :

innodb_buffer_pool_size = 256M

the default is 8M