Details
-
Task
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
None
-
None
-
None
Description
It seems that aria_used_for_temp_tables is not consistent with other system variables. It should be aria_used_for_tmp_tables. (tmp not temp)
MariaDB [ek]> show variables like '%temp%';
|
+---------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------+-------+
|
| aria_used_for_temp_tables | ON |
|
+---------------------------+-------+
|
1 row in set (0.00 sec)
|
 |
MariaDB [ek]> show variables like '%tmp%';
|
+-------------------+----------+
|
| Variable_name | Value |
|
+-------------------+----------+
|
| max_tmp_tables | 32 |
|
| slave_load_tmpdir | /tmp |
|
| tmp_table_size | 33554432 |
|
| tmpdir | /tmp |
|
+-------------------+----------+
|
4 rows in set (0.00 sec)
|
It should also be noted that in MySQL 5.6, they've just made: default_tmp_storage_engine as a system variable (set to InnoDB as a default). http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_default_tmp_storage_engine