MySQL Forums
Forum List  »  InnoDB

Internal Temporary tables
Posted by: Marcello La placa
Date: February 10, 2013 04:11PM

I have a question about the internal temporary tables which are created when ever ORDER BY or GROUP BY are used.
As far I understood the internal temporay tables are created initially in memory,but if the size id too big then it is converted in a on-disk table using the MyISAM engine.
Because I suppose that is the same whenever Innodb is used, I am wondering if doing some MyISAM settings will help to speed up the creation if those temporary tables whenever the statement ORDER BY or GROUP BY are using over a Innodb Database.


Options: ReplyQuote

Written By
Internal Temporary tables
February 10, 2013 04:11PM
February 11, 2013 11:09PM
February 20, 2013 02:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.