← Home

#mysql

10 posts, oldest → newest

• MySQL - DBA Toolkit - Binary Log Health
  2026-04-04 — Database Administration — Monitor binary log status, current log file, position, and retention to ensure replication and point-in-time recovery are healthy.
• MySQL - DBA Toolkit - Connection Usage and Limits
  2026-04-05 — Database Administration — Check current connection counts, max_connections limits, and identify who is consuming connections before you hit the wall.
• MySQL - DBA Toolkit - Deadlocks
  2026-04-06 — Database Administration — Detect and investigate MySQL deadlocks using InnoDB status, performance_schema, and the last deadlock report.
• MySQL - DBA Toolkit - Active Sessions and Threads
  2026-04-07 — Database Administration — See every active session and thread at a glance — who is running what, for how long, and where your connection headroom sits.
• MySQL - DBA Toolkit - Index Usage and Missing Indexes
  2026-04-07 — Database Administration — Identify unused indexes wasting write overhead and large tables with no useful indexes that will cause full scans under load.
• MySQL - DBA Toolkit - InnoDB Buffer Pool Health
  2026-04-07 — Database Administration — Check InnoDB buffer pool hit rate, utilization, and dirty page pressure to understand whether your working set fits in memory.
• MySQL - DBA Toolkit - Lock Waits
  2026-04-07 — Database Administration — Surface active InnoDB lock waits and long-running transactions to identify what is blocking and how long it has been doing so.
• MySQL - DBA Toolkit - Replication Lag and Status
  2026-04-07 — Database Administration — Check replica status, seconds behind source, I/O and SQL thread health, and GTID consistency to catch replication problems before they become outages.
• MySQL - DBA Toolkit - Slow Query Analysis
  2026-04-07 — Database Administration — Find the queries consuming the most cumulative time using performance_schema digest statistics, without needing the slow query log.
• MySQL - DBA Toolkit - Table Size and Growth
  2026-04-07 — Database Administration — Identify your largest tables, compare data versus index footprint, and spot fragmentation that can be reclaimed with a table rebuild.