1.2 KiB
1.2 KiB
Phase 69 — Database Diagnostics
Adds advisory diagnostics to the existing Server Administration monitoring pages.
- Slow Query Analysis: flags statement digests with reported non-index usage and high examined/returned row ratios.
- Table I/O Hotspots: highlights heavily accessed tables based on cumulative Performance Schema counters.
- InnoDB Lock Waits: displays a warning when blocking relationships are present.
- Connection Statistics: flags aborted connections and disk-based temporary tables.
- Copy Report exports the complete diagnostic findings for the current snapshot.
All findings are read-only, computed from existing server query results, and should be interpreted as investigation prompts rather than definitive tuning instructions. Thresholds are intentionally conservative. No automatic schema modifications, server setting changes or query execution are performed by the diagnostic layer.
The existing performance dashboards, introspection, SQL autocomplete, data synchronisation previews and appearance settings remain unchanged.
Validation: Swift source was statically inspected; macOS compilation and live MySQL runtime verification are outstanding.