What Is MySQL Doing Right Now? Real-Time Analytics in PMM

When MySQL slows down, most people run SHOW FULL PROCESSLIST again and again. You get a wall of text, nothing about a minute ago, and no simple way to tell a slow query from a stuck one. Historical query analytics gives the answer later, when the incident is already over.

This session shows PMM Real-Time Analytics (RTA): a live view of the queries running right now, refreshed every two seconds, read from performance_schema. RTA covers MongoDB today, and MySQL support is on the way. We follow one incident from start to finish. We open a session, find the query that is slowing the server down, and read what we need to decide: how many rows it reads against how many it returns, whether it scans a whole table, what the thread is doing, and who is running it. The full processlist row is one click away.