Mysql 常见问题汇总：

ERROR 1206 (HY000): The total number of locks exceeds the lock table size
解决办法：更改innodb_buffer_pool_size的设置，这个参数定义了InnoDB存储引擎的表数据和索引数据的最大内存缓冲大小。打开Mysql 命令行模式：

mysql> show variables like "innodb_buffer_pool_size";
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 8388608 |
+-------------------------+------------+

# 默认可用内存为8MB，将其改为2GB
mysql> set global innodb_buffer_pool_size = 2147483648;
Query OK, 0 rows affected (0.02 sec)

# 检查设置结果
mysql> show variables like "innodb_buffer_pool_size";
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 2147483648 |
+-------------------------+------------+
1 row in set, 1 warning (0.01 sec)