Data Monitoring
An operator wants an execution plan for a potentially expensive statement. Distinguish EXPLAIN estimates from EXPLAIN ANALYZE execution and inspect the statement's side effects.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: Analyze versus execute safety
Data Monitoring
Backups exist but WAL archival has stopped advancing. Inspect pg_stat_archiver and the configured archive destination alongside recent WAL production.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Archive pipeline failures
Data Monitoring
Repeated statistics reads inside one transaction appear unchanged. Check PostgreSQL statistics snapshot behavior and the collector's transaction scope.
PostgreSQL Monitoring1 min read
Read article : PostgreSQL: Statistics snapshot interpretation
Data Monitoring
A replicated standby is mistaken for a complete backup strategy. Compare independent backups, archived WAL and an isolated restore test with the recovery objective.
PostgreSQL Monitoring2 min read
Read article : PostgreSQL: PostgreSQL recovery drill evidence
Data Monitoring
MySQL has many connections but only a few statements executing. Compare Threads_connected and Threads_running with application pool waits.
MySQL Monitoring2 min read
Read article : MySQL: Threads running versus connected
Data Monitoring
A diagnostic table is empty although the workload is active. Check instruments, consumers and retained history capacity for the required event type.
MySQL Monitoring1 min read
Read article : MySQL: Performance Schema instrumentation
Data Monitoring
A query with low average time dominates total database work. Compare digest execution counts, total latency and per-call latency.
MySQL Monitoring1 min read
Read article : MySQL: Statement digest ranking
Data Monitoring
Users report timeouts but the configured slow log captures little. Compare logging thresholds, statement duration and whether the relevant workload qualifies for collection.
MySQL Monitoring2 min read
Read article : MySQL: Slow query log thresholds
Data Monitoring
Updates queue behind a transaction that appears unrelated. Inspect lock wait relationships and transaction context using supported Performance Schema tables.
MySQL Monitoring1 min read
Read article : MySQL: InnoDB row lock waits
Data Monitoring
A schema change hangs behind an application transaction. Compare metadata lock evidence, active DDL and long transactions referencing the object.
MySQL Monitoring1 min read
Read article : MySQL: Metadata lock waits
Data Monitoring
Deadlock retries succeed but transaction latency grows. Compare deadlock evidence, retry count and end-to-end application duration.
MySQL Monitoring1 min read
Read article : MySQL: Deadlock trend interpretation
Data Monitoring
A replica receives changes but fails to apply them. Inspect replica status and worker errors, distinguishing retrieval progress from execution progress.
MySQL Monitoring1 min read
Read article : MySQL: Replica receiver versus applier