Skip navigation links

MySQL Forums :: InnoDB :: Internal Temporary tables


Advanced Search

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 794 Marcello La placa 02/10/2013 04:11PM
Re: Internal Temporary tables 471 Rick James 02/11/2013 11:09PM
Re: Internal Temporary tables 364 Marcello La placa 02/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.