#MySQL踩坑记录及解决方案

坑号1206

1206 - The total number of locks exceeds the lock table size

1206填坑方案

#扩大缓存
SET GLOBAL  tmp_table_size =1024*1024*1024;
SET GLOBAL innodb_buffer_pool_size=3*1024*1024*1024;