[MDEV-6537] Documentation Update Request: Add more details about aria_used_for_temp_tables Created: 2014-08-05 Updated: 2014-08-07 Resolved: 2014-08-07 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | 10.0.13 |
| Type: | Task | Priority: | Minor |
| Reporter: | Chris Calender (Inactive) | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
I would like to request we add some more details about the following variable: aria_used_for_temp_tables. It's clear that the value is enabled by default and uses aria_pagecache_buffer_size if the value is ON. It's not clear is what happens if the value is OFF. Fwiw, I think it simply defaults to MyISAM, per: http://dev.mysql.com/doc/refman/5.6/en/internal-temporary-tables.html On a somewhat related note, regarding the MySQL page above, I filed a feature request with them to elaborate on that exact page about the new variable "default_tmp_storage_engine": http://bugs.mysql.com/bug.php?id=73477 The gist of that is to describe the meaning of "default_tmp_storage_engine" on that page, since it is a new variable in MySQL 5.6, and very relevant to that page. MariaDB has added this variable to MariaDB 10.1.0, so that is something to perhaps keep in mind when describing what OFF means: https://mariadb.atlassian.net/browse/MDEV-6107 Not to mention, I've requested we backport this variable to 10.0 also, though not sure if this idea will be accepted or not. |
| Comments |
| Comment by Sergei Golubchik [ 2014-08-06 ] |
|
When aria_used_for_temp_tables is ON, then MariaDB uses Aria engine for internal on-disk temporary tables. If it is OFF, MariaDB uses MyISAM for internal on-disk temporary tables. In either case MariaDB uses MEMORY for internal temporary table when appropriate. default_tmp_storage_engine specifies what engine to use for CREATE TEMPORARY TABLE, it does not affect internal temporary tables. |
| Comment by Ian Gilfillan [ 2014-08-07 ] |
|
Documentation has been expanded: https://mariadb.com/kb/en/mariadb/documentation/storage-engines/aria/aria-system-variables/#aria_used_for_temp_tables |