Bug #59375 tmp_table_size sysvar description wrong

• Submitted: 9 Jan 2011 4:53
• Modified: 13 Jan 2011 23:13
• Reporter: Erik Ljungstrom (OCA)
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.5
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any
• Tags: tmp_table_size

[9 Jan 2011 4:53] Erik Ljungstrom

Description:
Under http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_tmp_table_size it says 
"If an in-memory temporary table exceeds the limit, MySQL automatically converts it to an on-disk MyISAM table"

This appears to be an InnoDB table as this is the default in version 5.5.

How to repeat:
N/A

Suggested fix:
Change MyISAM to say either "InnoDB", or "the server's default storage engine"

[13 Jan 2011 20:40] Paul DuBois

Actually, internal on-disk temporary tables are MyISAM no matter the default storage engine:
http://dev.mysql.com/doc/refman/5.5/en/internal-temporary-tables.html

If you mean CREATE TEMPORARY TABLE, then it will be the default storage engine if no ENGINE option is specified. But that's not what tmp_table_size is about.

[13 Jan 2011 23:14] Erik Ljungstrom

Right you are, I clearly misinterpreted something when I looked at this, I was lead to believe this had changed. 
Apologies for having wasted your time!