Hey, we explicitly create temporary tables in order to use indexes in some of our stored procedures. Right now we do not specify storage engine, so it defaults to InnoDB. Im realizing that if we explicitly use the MEMORY storage engine we'll likely get much better performance. The question is what happens if the tables grow to big (individually or cumulatively) will Mysql automatically revert to using disk based tables in those instances (even though we explicitly create the temporary table as MEMORY) or will Mysql start returning errors?
No announcement yet.
Temporary Tables with MEMORY Storage EnginePage Title Module
Move Remove Collapse