Linko22's Wiki

Это старая версия документа!

---

# mysql
mysql> set @@global.tmp_table_size=327680000;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
 
# mysql
mysql> show variables like '%tmp%';
+-------------------+-----------+
| Variable_name     | Value     |
+-------------------+-----------+
| max_tmp_tables    | 32        |
| slave_load_tmpdir | /tmp      |
| tmp_table_size    | 327680000 |
| tmpdir            | /tmp      |
+-------------------+-----------+
4 rows in set (0.00 sec)
 
mysql>

old value

set @@global.tmp_table_size=134217728;
set @@global.max_heap_table_size=268435456;

512Mb

set @@global.tmp_table_size=536870912;
set @@global.max_heap_table_size=536870912;