The total number of locks exceeds the lock table size？

执行存储过程的时候出现错误
The total number of locks exceeds the lock table size修改了innodb_buffer_pool_size＝800M
还是一样
怎么解决？

解决方案 »

  1.   

    检查一下 max_write_lock_count 
    [code=BatchFile]mysql> show variables like '%lock%';
    +--------------------------------+------------+
    | Variable_name                  | Value      |
    +--------------------------------+------------+
    | innodb_autoinc_lock_mode       | 1          |
    | innodb_lock_wait_timeout       | 50         |
    | innodb_locks_unsafe_for_binlog | OFF        |
    | innodb_table_locks             | ON         |
    | max_write_lock_count           | 4294967295 |[/code]