1、啟動(dòng)選項(xiàng)中修改
啟動(dòng)mysql的時(shí)候加參數(shù) -O max_heap_table_size=64M 。
2、修改my.cnf
在[mysqld]的段中 增加 max_heap_table_size = 32M
3、在mysql客戶端工具中修改
mysql> set max_heap_table_size=32777216;
Query OK, 0
rows affected (0.00 sec)
mysql> show variables like
'%heap%';
+---------------------+----------+
|
Variable_name | Value |
+---------------------+----------+
| max_heap_table_size |
32777216 |
+---------------------+----------+
1 row in
set (0.00 sec)