MySQL 8 new features: Temptable engine

Tuesday 5:55 PM - 6:20 PM

@ Dow


25 minutes conference



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 Pla

Pep Pla (Pythian)

Database Consultant


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.


  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863