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.
Pep has a broad experience in several database platforms, but in recent years he has focused on MySQL. His work abides by the motto of Mission Control at NASA: "Tough and competent". Tough means you are accountable for what you do or fail to do, it means compromise and responsibility. Competent means that you take nothing for granted and you must never be found short in knowledge and skills. This is how Pep feels and lives database management. He is also interested in applying Lean culture to his job and enjoys living in Barcelona with his kids and his partner.