Toggle MySQL's slow_query_log from the UI, tail it inline, get a daily digest of the top N slow queries. The thing you keep telling yourself you'll set up "properly" — already set up.
Turning it on is a runtime setting, not a restart — so it can be enabled during the incident and off again after.
Reads are bounded — 500 lines by default, 2000 at most — so tailing a huge log does not take the agent with it.
It is resolved from @@slow_query_log_file at read time, so a customised location still works.
slow_query_log on and off via SET GLOBAL, no restart.long_query_time at 0.5, 1, 2, 5 or 10 seconds.long_query_time = 0.5 to balance signal vs. noise.MySQL Slow-Log Viewer from Starter.