The Monday morning report: four hours of MySQL replica lag
Four hours of lag on a MySQL replica in a logistics system. How we diagnosed it, why Seconds_Behind_Master lies, and what actually fixed it.
Monitoring
3 tagged articles
MySQL
PostgreSQL
pg_stat_statements: the first thing to install on any PostgreSQL
PostgreSQL pg_stat_statements: the first query diagnostics extension to install. Find the three queries consuming 80% of database resources.
Oracle
AWR, ASH and the 10 minutes that saved a go-live
Oracle 19c performance tuning with AWR and ASH: finding a hidden full table scan in a stored procedure in 10 minutes, the eve of a go-live.