1
Verify the likely cause
Import in smaller committed batches, preserve primary-key order and inspect replication worker utilization before adding more threads.
FULL AI ANALYSIS
MySQL replica lag grows during nightly imports
Generated Sep 17, 2026, 11:55:04 PM
Analysis summary
The reported behaviour is consistent with large transactions serialize replication and retain locks until the entire batch commits. The safest next step is to verify that hypothesis with a reversible test before making permanent configuration changes.
Possible causes
Large transactions serialize replication and retain locks until the entire batch commits.
86%A recent software, firmware or configuration change is exposing an existing compatibility issue.
40%Suggested fixes
2
Validate and monitor
Reproduce the issue once after the change, review relevant logs or metrics, and keep a rollback path until the system has remained stable.