MySQL and MariaDB Replication IO Thread Stopped Alert


Use the Replication IO Thread Stopped alert in Mini DBA to monitor MySQL and MariaDB instances and make this condition visible before it becomes a wider database incident.

Screenshot pending: Mini DBA MySQL and MariaDB Replication IO Thread Stopped alert screenshot placeholder

Alert Summary

  • Platform: MySQL and MariaDB
  • Alert category: Availability
  • Default enabled: true
  • Default evaluation frequency: Minute

What Mini DBA Checks

Mini DBA describes this alert as: A MySQL replica IO thread is not running. The replica is not receiving changes from its source, so recovery point objectives and read-scale workloads may be at risk. The default evaluation frequency is Minute, so the alert is intended to be close enough to operational reality for live triage.

Why This Alert Is Helpful

This alert protects high availability and disaster recovery by warning when replicas, replication slots, or apply processes fall behind. Lag can turn a planned failover into data loss risk or leave reporting users looking at stale data.

When To Enable It

Enable it where replication, read replicas, failover, or reporting copies are part of the service design. Disable it on standalone systems that do not use replication so the alert list stays focused.

Threshold Guidance

This alert is not primarily driven by a numeric threshold in Mini DBA. Tune the schedule, scope, severity, and notification route so that the alert matches the importance of the instance. Use higher thresholds on batch-heavy, development, or intentionally bursty systems where brief pressure is expected. Use lower thresholds on latency-sensitive production systems, small instances with little headroom, and services with strict recovery or availability commitments.

Remediation For An Active Alert

Check the sender, receiver, apply process, network path, and oldest retained log position. Restart failed replication workers only after capturing the error, then address the root cause such as disk pressure, long transactions, schema drift, network latency, or insufficient replica capacity.

Investigation Workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the top consumers, host counters, service tier or instance size, and recent workload changes in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding Alert Noise

If this alert is noisy, check whether the workload naturally has short bursts. Raise the duration or threshold for expected batch windows, but keep a lower route for production systems where user-facing latency matters. Avoid simply disabling the alert until you know whether the noise is caused by threshold choice or by a real capacity trend.

Related Pages