MySQL配置文件路径及‘The total number of locks exceeds the l_MySQL

ERROR 1206 (HY000): The total number of locks exceeds the lock table size

mysql> show variables like '%_buffer%';+-------------------------+---------+| Variable_name           | Value   |+-------------------------+---------+| bulk_insert_buffer_size | 8388608 || innodb_buffer_pool_size | 8388608 |

innodb_buffer_pool_size = 256M

/home/mysql/bin/mysqld --verbose --help | grep -A 1 'Default options'

Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf /home/mysql/etc/my.cnf ~/.my.cnf

mysql> show variables like '%_buffer%';+-------------------------+-----------+| Variable_name           | Value     |+-------------------------+-----------+| bulk_insert_buffer_size | 8388608   || innodb_buffer_pool_size | 268435456 |...