MySQL Forums :: InnoDB :: Storage engine used by temporary tables


Advanced Search

Storage engine used by temporary tables
Posted by: James Brown ()
Date: October 01, 2010 02:36AM

What storage engine do temporary tables use? I mean, if MySQL thinks that create a temporary table when executing a complex query is needed, what storage engine does it use? Can it be modified? Is it the same storage engine than the one used by the tables in the database?

Thank in advance!

Options: ReplyQuote


Subject Views Written By Posted
Storage engine used by temporary tables 2970 James Brown 10/01/2010 02:36AM
Re: Storage engine used by temporary tables 7353 Rick James 10/02/2010 04:22PM
Re: Storage engine used by temporary tables 1827 James Brown 10/03/2010 10:35AM
Re: Storage engine used by temporary tables 1585 Rick James 10/03/2010 10:44AM
Re: Storage engine used by temporary tables 1526 James Brown 10/06/2010 08:12AM


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.