MySQL and MariaDB Fragmented Tables Health Check


Use the Fragmented Tables health check in Mini DBA to review MySQL and MariaDB configuration, metadata, and monitoring signals before they become active alerts.

Screenshot pending: Mini DBA MySQL and MariaDB Fragmented Tables health check screenshot placeholder

Health Check Summary

  • Platform: MySQL and MariaDB
  • Health check category: Performance

What This Health Check Means

This health check looks for storage layout, growth, or space-management choices that can cause avoidable outages or uneven performance.

Why It Matters

Storage and file-layout problems can create sudden outages or long-running waits. This check makes those risks visible before they block user work.

What To Do If It Fails

Move files away from fragile locations, pre-size growth-heavy files, fix uneven growth, add capacity, and review retention or cleanup jobs. Avoid shrinking files unless the growth was a one-time exception.

Review Workflow

  1. Open the health check result and identify file placement, growth settings, free space, retention rules, and the operational owner for storage changes.
  2. Decide whether the condition is intentional, inherited from a legacy system, or caused by recent change.
  3. Validate the fix in a lower environment or during a safe maintenance window when the change can affect plans, storage, or access.
  4. Rerun or refresh the health check after remediation so the Mini DBA health view reflects the new state.

Evidence To Collect

Keep evidence of current size, free space, growth history, retention settings, and who approved any storage or file-layout change.

How To Prioritize It

Treat a failure as high priority on production systems because it can affect recoverability, availability, or security posture.

Prevention And Ownership

Prevent repeat failures by reviewing capacity trends alongside alert history. If the same check returns after each fix, treat it as a sizing or design issue rather than a one-off maintenance task.

Runbook Use

Add this page to the operational runbook for MySQL and MariaDB environments where the check repeatedly fails. Record local thresholds, approved exceptions, escalation contacts, and the expected review interval so the next administrator can act quickly without rediscovering the same context.

Related Pages