Questions about temporary tables
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?
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.