-
-
Notifications
You must be signed in to change notification settings - Fork 0
Diagnostic: Table Fragmentation and Disk Overhead #5271
Copy link
Copy link
Open
Labels
DiagnosticA diagnostic health checkA diagnostic health checkPriority 02 (Medium)Important improvements supporting our core principlesImportant improvements supporting our core principlesStatus (Needs Triage)Needs initial review and categorizationNeeds initial review and categorization
Milestone
Description
Metadata
Metadata
Assignees
Labels
DiagnosticA diagnostic health checkA diagnostic health checkPriority 02 (Medium)Important improvements supporting our core principlesImportant improvements supporting our core principlesStatus (Needs Triage)Needs initial review and categorizationNeeds initial review and categorization
Deleted rows leave unused space (DATA_FREE) in InnoDB tables, causing fragmentation that slows queries and backups. Report DATA_FREE for all tables and flag excessive overhead.
Diagnostic Goal: Report table fragmentation statistics; flag >10% overhead or >100 MB DATA_FREE.
Treatment Mode: Automated OPTIMIZE TABLE on flagged tables.
Scope: information_schema.TABLES for site tables.
Acceptance: Calculates fragmentation correctly, treatment optimizes and reclaims space, no false positives.