MySQL Forums
Forum List  »  Newbie

Questions about temporary tables
Posted by: Ludvig Boman
Date: March 06, 2021 05:22AM

I would like to know what happens when you create a temporary table if you don't specify Engine type. Is it stored on disk or in memory? What do you recommend for the best performance, should I use Engine=InnoDB or Engine=Memory for temporary tables? Or should I not specify engine at all? Is there any way to let MySQL choose if the temporary table should be stored on disk or in memory based on what it thinks is the best for performance?

Also, I have read somewhere that the Memory storage engine is "non-transactional"? What does that mean? Will there be a problem if I use temporary tables with the Memory engine in a transaction?

Options: ReplyQuote


Subject
Written By
Posted
Questions about temporary tables
March 06, 2021 05:22AM


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.