Optimizing MySQL performance can seem complex and time-consuming. Where do you start? Tweaking variables? Upgrading hardware? When dealing with poorly written queries, these kinds of changes merely mask the problem temporarily rather than solving it.
The goal of this talk is to clarify the process of creating, analyzing, and optimizing your queries. We will explore how the MySQL optimizer reads your code, why simply creating an index won’t always save a query, and the actual logic behind slow query performance.
This presentation is entirely inspired by concepts from Daniel Nichter’s book Efficient MySQL Performance (such as “Thinking like MySQL” and “It was a good index until…”).
Event
Speaker card
