MySQL Forums
Forum List  »  InnoDB

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

Hello,
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.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Internal Temporary tables
1800
February 10, 2013 04:11PM
922
February 11, 2013 11:09PM
811
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.