mysql删除表中数据报错:[Err] 1206 - The total number of locks exceeds the lock table size

查看缓冲池:

show variables like "%innodb_buffer_pool_size%";

配置缓存池(2G)大小:

SET GLOBAL innodb_buffer_pool_size=2147483648;

查看内部内存临时表的大小:

show variables like "%tmp%"

配置内存临时表(2G)大小:

SET GLOBAL tmp_table_size=2147483648;