Features · Monitoring · MySQL Slow-Log Viewer
Monitoring · MySQL Slow-Log Viewer

Slow-log on, slow-log off,
top offenders inline.

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.

slow_query_log · db-prod-02
state on · long_query_time 1.0 today 412 queries logged top offender SELECT … FROM sessions its mean 2.8s over 90 calls digest daily 07:00, top 10
— Why this matters

Diagnosing a slow query should not require SSH.

01

The log is usually off when you need it.

Turning it on is a runtime setting, not a restart — so it can be enabled during the incident and off again after.

02

A multi-gigabyte log will hang a naive reader.

Reads are bounded — 500 lines by default, 2000 at most — so tailing a huge log does not take the agent with it.

03

The path is not always where the docs say.

It is resolved from @@slow_query_log_file at read time, so a customised location still works.

— What's included

What the panel gives you.

One-click toggle
slow_query_log on and off via SET GLOBAL, no restart.
Threshold slider
long_query_time at 0.5, 1, 2, 5 or 10 seconds.
Auto-prep
The agent creates the log directory with the right ownership if it is missing — which is what usually causes the silent failure.
Inline tail
The last N lines, monospaced, on demand.
Top-offenders digest
Normalised queries ranked by total time, with count, total, max, average and rows examined.
— Works with

Connected capabilities

— FAQ

Questions, answered honestly.

Does enabling slow log impact production? +
Mild — single-digit % CPU overhead at typical settings. We default to long_query_time = 0.5 to balance signal vs. noise.
Where is the slow log stored? +
On the host (where MySQL writes it). We tail it via the agent; nothing leaves unless you open the viewer.
Postgres equivalent? +
Yes — pg_stat_statements integration ships in a parallel viewer (Day-1-Post-Beta).

Use the slow log without it owning you.

MySQL Slow-Log Viewer from Starter.

Get early access Back to Monitoring