Bug #52335 New @@SESSION.TEMP_TBL_STORAGE_ENGINE, @@GLOBAL.TEMP_TBL_STORAGE_ENGINE
Submitted: 24 Mar 2010 15:19 Modified: 24 Mar 2010 18:03
Reporter: Kevin Benton Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1.32 OS:Any
Assigned to: CPU Architecture:Any

[24 Mar 2010 15:19] Kevin Benton
Description:
Please add a session level variable setting the storage engine for temporary tables separately from STORAGE_ENGINE.  In our shop, over 90% of our tables are InnoDB but we really need to make sure that temporary tables are created using the MyISAM storage engine.  We don't have a way to tell the system to default to InnoDB for everything except temporary tables.  I believe a variable like this would facilitate that.

For example, when doing large selects, having MySQL using InnoDB as the storage engine wastes a rather large chunk of disk space and is far more wasteful than the same data set in MyISAM.  Also, InnoDB forces both a non-contextual primary key and an index to be created in the temporary table even if none is desired.

How to repeat:
See description.

Suggested fix:
See description.
[24 Mar 2010 15:29] Valeriy Kravchuk
Looks like a duplicate of bug #49232. Please, check.