[MDEV-12013] Server's Variable: default_tmp_storage_engine - Documentation Unclear Created: 2017-02-07  Updated: 2017-02-10  Resolved: 2017-02-10

Status: Closed
Project: MariaDB Server
Component/s: Configuration, Data Definition - Temporary, Documentation
Affects Version/s: 10.1.20, 10.1.21
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: Juan Telleria Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: Aria, Temporary, optimizer
Environment:

Windows 7


 Description   

MariaDB "default_tmp_storage_engine" System's Variable is not clear enough.

  • By default it has a value of NULL. ¿What does that mean? ¿That the default server's engine for temporary tables (CREATE TEMPORARY TABLE) is that from "default_storage_engine"? Documentation is not clear enough.
  • Also, when choosing "Memory" Engine for tables created via "CREATE TEMPORARY TABLE", when exceeded "max_heap_table_size", ¿Are tables automatically converted to Aria Engine? (As it happens with internal temporary tables) 

    SET @@default_tmp_storage_engine = memory;

Thank you,
Juan

 Comments   
Comment by Ian Gilfillan [ 2017-02-10 ]

Documentation updated. The engine type will be taken from default_storage_engine if the setting is NULL, and CREATE TEMPORARY tables of type Memory are not converted.

Comment by Juan Telleria [ 2017-02-10 ]

Thank you Ian.

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