⚡ MySQL Advisor

SHOW ENGINE INNODB STATUS Advisor (SEIS)

Paste the output of SHOW ENGINE INNODB STATUS and read it one section at a time, with the output on the left and what it means on the right. It works across MySQL 5.7 through 8.4, Percona Server, Percona XtraDB Cluster and MariaDB, even though each formats these sections a little differently. And where a number genuinely cannot be judged from the output alone, it tells you that instead of guessing.

Verification code image

Run it as: SHOW ENGINE INNODB STATUS\G, then paste the whole thing, including the ===== fences. Two captures a minute apart tell you far more than one, because most of what matters here is a rate of change, not a single number. For an incident, take several samples (for example every 15 to 30 seconds for several minutes) and read the trend, and use one collector at a time, because heavy collection can itself stall a busy server. You can paste several captures at once, or a stretch of the error log that contains them: each capture is read on its own, and you can switch between them.
What happens to it: the text is parsed on the server and handed straight back to this page. Nothing is stored and nothing is logged. Worth knowing though: this output contains query text, and the record dumps in the deadlock and foreign key sections can contain row data in readable form, so treat a capture from a production server like you would any other sensitive data.