[MDEV-6538] aria_used_for_temp_tables cannot be set via my.cnf or my.ini file Created: 2014-08-05  Updated: 2022-03-22  Resolved: 2014-08-06

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Chris Calender (Inactive) Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows and Linux

Issue Links:
Relates
relates to MDEV-6630 make aria_used_for_temp_tables a modi... Open

 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.

 Comments   
Comment by Sergei Golubchik [ 2014-08-06 ]

aria_used_for_temp_tables is a read-only variable, the only way to change it is to recompile MariaDB

Comment by Chris Calender (Inactive) [ 2014-08-07 ]

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

Comment by Sergei Golubchik [ 2014-08-22 ]

Correct.
Yes.
Yes, although you can allocate very little memory to MyISAM, if you don't use it.
Okay, see MDEV-6630.

Comment by Michael Widenius [ 2022-03-22 ]

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.

Generated at Thu Feb 08 07:12:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.