MySQL 8 new features: Temptable engine

Tuesday 5:55 PM - 6:20 PM

@ Dow

MySQL/MariaDB

25 minutes conference

Beginner

Tracks:
Tutorial

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.


Speakers

Pep Pla

Pep Pla (Pythian)

Database Consultant

Biography:

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.


Slides



  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(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA