运维进行时

故障现象
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，解决。