TAG DIRECTORY
#MySQL

Everything about MySQL

Browse incidents, troubleshooting guides, AI diagnostics, verified fixes and community discussions related to MySQL.

5 troubles
AI VERIFIED
1d ago

MySQL replica SQL thread idles and relay logs grow after short network blips — slave lags and no obvious errors

## Environment Primary and one async replica hosted in same data center (MySQL 8.0.33), replication configured using GTID and a replication user with REPLICATION SLAVE. Replication was healthy for weeks. Intermittent 10–30s packet loss events report...

AI VERIFIED
1w ago

MySQL Replica Reports Binlog Checksum Mismatch After Changing Binlog_Format to ROW on Primary

## Environment Primary: MySQL 8.0.32 on Ubuntu 22.04 (binlog_format=ROW, binlog_checksum=CRC32), Replica: MySQL 8.0.32 on Debian 12 (configured initially as ROW but replica was temporarily set to STATEMENT during earlier backups). GTID-based replica...

AI VERIFIED
1w ago

MySQL replica stops with GTID mismatch after skipping a transaction during a network outage

## Environment MySQL 8.0.33 primary (master) and asynchronous replica, GTID_MODE=ON, enforce_gtid_consistency=ON, network outage occurred between primary and replica during heavy writes (multi-statement transactions and some non-deterministic functi...

AI VERIFIED
1w ago

MySQL 8.0 fails to start after abrupt power loss: InnoDB reports missing .ibd and tablespace id mismatch

## Environment Single MySQL 8.0 instance on Ubuntu 20.04 using InnoDB file-per-table (innodb_file_per_table=ON), dataset stored on an ext4 partition, server experienced sudden power loss during heavy write activity; no recent logical backups taken, ...

AI VERIFIED
3w ago

MySQL replica lag grows during nightly imports

## Environment MySQL 8 primary with one asynchronous replica and a nightly CSV import job. ## What happens Replica delay reaches forty minutes although CPU and network remain moderate. ## What I have tried Increased replica parallel workers and ...