Lots of database operations require the use of temporary tables. MySQL creates these temporary tables transparently, but this behaviour can be tuned and configured for optimal performance.
MySQL 8 introduces a new engine for in-memory temporary tables, that can replace the Memory engine used in previous releases.
In this session, we will offer an overview of the operations that require temporary tables and present the configuration options that rule this feature.
We will also show some benchmarks to compare the performance of the different internal temporary table engines.