Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.0.12
-
None
-
None
-
Windows and Linux
Description
The variable, aria_used_for_temp_tables, cannot be set via the config (my.cnf, my.ini) file.
This variable is set to ON by default.
mysql> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 10.0.12-MariaDB |
|
+-----------------+
|
|
|
mysql> show global variables like 'aria_used_for_temp_tables';
|
+---------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------+-------+
|
| aria_used_for_temp_tables | ON |
|
+---------------------------+-------+
|
However, if you try to set it explicitly in the config file, you will receive an error:
[mysqld]
|
aria_used_for_temp_tables=ON
|
Note I also tried:
aria_used_for_temp_tables=1
|
aria_used_for_tmp_tables=ON
|
aria_used_for_tmp_tables=1
|
All 4 failed:
140805 15:49:39 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_temp_tables=ON'
|
|
|
140805 15:50:15 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_temp_tables=1'
|
|
|
140805 15:51:20 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_tmp_tables=1'
|
|
|
140805 15:51:39 [ERROR] C:\Program Files\MariaDB 10.0\bin\mysqld.exe: unknown variable 'aria_used_for_tmp_tables=ON'
|
Note I tried the latter 2 options because of this bug, thinking perhaps that might work:
https://mariadb.atlassian.net/browse/MDEV-4563
I'd suggest if you're going to fix this bug, then I think 4563 should be fixed first, if it is going to be.
Attachments
Issue Links
- relates to
-
MDEV-6630 make aria_used_for_temp_tables a modifiable variable
-
- Open
-
Activity
If aria_used_for_temp_tables is a read-only variable, and not able to be set, then you are forcing everyone to have temp tables written to disk be of type aria, correct?
This forces users to allocate more RAM to "aria_pagecache_buffer_size", no?
If so, then one must allocate RAM for InnoDB (in 99% of cases), MyISAM, and ARIA.
This should be configurable (major reason being so people do not have to reduce RAM allocations from an existing storage engine buffer to add it to a third just for temp tables and their performance).
Please consider this, or at least revert to a "feature request".
Best wishes,
Chris
Correct.
Yes.
Yes, although you can allocate very little memory to MyISAM, if you don't use it.
Okay, see MDEV-6630.
In 10.6 and above, you don't have to allocate any notable memory to MyISAM if one is not going to use it at all. 64K would be more than enough.
aria_used_for_temp_tables is a read-only variable, the only way to change it is to recompile MariaDB