批量插入数据的时候提示

SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size

解决方法，修改innodb_buffer_pool_size大小

vi /etc/my.cnf,在[mysqld]中新增

innodb_buffer_pool_size=10G

重启