[MDEV-4563] aria_used_for_temp_tables should be tmp not temp Created: 2013-05-22  Updated: 2017-11-30

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: Colin Charles Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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



 Comments   
Comment by Sergei Golubchik [ 2015-01-26 ]

I'd suggest not to rename aria_used_for_temp_tables, but to deprecate it. And add a compatibility variable internal_tmp_disk_storage_engine as a replacement.

Generated at Thu Feb 08 06:57:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.