https://blog.liuts.com/index.php zh-cn https://blog.liuts.com/post// root <admin@yourname.com> Thu, 22 May 2008 14:10:56 +0000 https://blog.liuts.com/post// 故障现象
mysql> delete FROM `tablesname` WHERE datetime<'2009-03-06'; ERROR 1206 (HY000): The total number of locks exceeds the lock table size
解决步骤
1、锁表写操作
mysql> lock tables tablesname write; mysql> delete FROM `tablesname` WHERE datetime<'2009-03-06'; ERROR 1206 (HY000): The total number of locks exceeds the lock table size
没有解决。
2、 innodb修改改innodb_buffer_pool_size值(一般配置为总内存的30%-40% ) myisam修改key_buffer(若是myisam应该没这个问题,因为myisam不是行级锁)
重启Mysql，解决。
Tags - lock , table ]]> https://blog.liuts.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://blog.liuts.com/post//#blogcomment