Let's Talk About MySQL Query Tuning

Speakers:  Gabriel Ciciliani

Let’s Talk About MySQL Query Tuning

This session was presented on Percona Community Live Online June 21-23, 2022. Check out the full schedule here.

Regardless of development frameworks, despite linters, besides countless sessions with the DBA, slow queries always end up making it to production. Proactive and reactive slow query tuning is still critical to ensure poorly written queries aren’t undermining server performance and wasting valuable compute resources. Cloud-based database managed services are not the exception: slow query root cause analysis requires human intervention. In this session I will discuss why slow query tuning is more relevant than ever, how to detect problems and guidelines to fix them.

Watch Video Here

Link: https://youtu.be/nOq66VzIOKg

Transcript

Speakers

Gabriel Ciciliani

Independent consultant

Gabriel has been dedicated to databases as a DBA and consultant for the last 15 years. He has led and participated in multiple projects across many technologies, including Oracle, MySQL, SQL Server and MongoDB. Gabriel defines himself as an automation super fan and he contributed to the development of two custom DBaaS platforms.

See all talks by Gabriel Ciciliani »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Read more »

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

In this episode, Joe Brockmeier interviews benny Vasquez of the AlmaLinux Project to discuss open source data, the future of databases, and how databases and Linux distros go together.

Read more »

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

In this episode, Joe Brockmeier talks to Percona’s Sonia Valeja and David Gonzalez, about their recent book PostgreSQL for Jobseekers. They talk about the inspiration for the book, why they focus on jobseekers, and what’s covered in the title.

Read more »

✎ Edit this page on GitHub