MySQL Forums
Forum List  »  MyISAM

Can't set global variable tmp_table_size
Posted by: Jamie Koc
Date: September 02, 2011 11:17AM

Documentation says this is a global dynamic variable.

mysql> SET @@global.tmp_table_size=67108864;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%tmp_table_size%';
+----------------+----------+
| Variable_name | Value |
+----------------+----------+
| tmp_table_size | 16777216 |
+----------------+----------+
1 row in set (0.00 sec)

mysql> set global tmp_table_size=67108864;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%tmp_table_size%';
+----------------+----------+
| Variable_name | Value |
+----------------+----------+
| tmp_table_size | 16777216 |
+----------------+----------+
1 row in set (0.00 sec)



Edited 1 time(s). Last edit at 09/02/2011 11:18AM by Jamie Koc.

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't set global variable tmp_table_size
12660
September 02, 2011 11:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.