Bug #73477 Add default_tmp_storage_engine to "How MySQL Uses Internal Temporary Tables"

• Submitted: 5 Aug 2014 18:47
• Modified: 12 Dec 2015 15:14
• Reporter: Chris Calender
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S4 (Feature request)
• Version: 5.6
• OS: Any
• CPU Architecture: Any
• Tags: default_tmp_storage_engine

[5 Aug 2014 18:47] Chris Calender

Description:
I propose to add something about "default_tmp_storage_engine" to the "How MySQL Uses Internal Temporary Tables" page in the manual, for 5.6+.

"default_tmp_storage_engine":

http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_default_tmp_sto...

"How MySQL Uses Internal Temporary Tables":

http://dev.mysql.com/doc/refman/5.6/en/internal-temporary-tables.html

This is an important new variable that should be documented on this page.

How to repeat:
N/A

Suggested fix:
N/A

[12 Dec 2015 15:14] Paul DuBois

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

default_tmp_storage_engine is for CREATE TEMPORARY tables, not internal temporary tables. However, in MySQL 5.7, the internal_tmp_disk_storage_engine system variable is available to control which storage engine to use for internal temporary tables. See:
http://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html