错误描述:
存储引擎是innodb,有时mysql 出现如下错误:ERROR 1206 (HY000): The total number of locks exceeds the lock table size
解决办法:
增加innodb_buffer_pool_size参数的值,Mysql默认这个参数的值为8M;增加max_write_lock_count 参数的值。
说明:
The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables. The default value is 8MB. The larger you set this value, the less disk I/O is needed to access data in tables. On a dedicated database server, you may set this to up to 80% of the machine physical memory size. However, do not set it too large because competition for physical memory might cause paging in the operating system.
|