Gabriel is a seasoned database consultant with nearly 20 years of experience optimizing performance across MySQL, Oracle, MongoDB, and SQL Server in enterprise environments. As both a developer and engineer, he has contributed to MySQL plugins and built two custom MySQL DBaaS platforms. Gabriel holds degrees in electronics, industrial engineering, and a master’s in information systems engineering, along with certifications from Google Cloud, Oracle, and Microsoft. In 2022, he founded query-optimization.com to help developers fix slow SQL queries. In 2024, he joined Releem to advance automated query optimization, making performance tuning one less thing businesses need to worry about.

Presentations

23x

The Hidden Lives of Temp Tables: Unraveling MySQL Internal Management

Ever wondered how MySQL and MariaDB handle the myriad internal temporary tables they create to process your queries? This session pulls back the curtain on this often-overlooked aspect of database performance. 

Prepare to have your assumptions challenged as we delve into the baffling behavior of MySQL's TempTable storage engine. We'll analyze the key configuration variables and internal mechanisms that influence this crucial decision.

Through practical examples and insightful explanations, you'll gain a deeper understanding of:

- When are internal temporary tables used
- How MySQL and MariaDB choose the storage engine
- The specific triggers and thresholds that cause MySQL engine to move data to disk and the performance impact
- Practical tips and configuration adjustments to optimize temporary table usage and avoid unexpected disk I/O.

Whether you're a seasoned DBA, a curious developer, or anyone interested in the inner workings of MySQL and MariaDB, this session will equip you with valuable knowledge to better understand and optimize your database performance.

See Presentation