SHOW REPLICA STATUS
SafeReplication status
SHOW REPLICA STATUS\G
Checks replica health: both threads Running=Yes and low Seconds_Behind_Source. Errors land in Last_Error.
Examples
SHOW REPLICA STATUS\GLag and errors at a glance
Syntax
SHOW REPLICA STATUS\G (旧: SHOW SLAVE STATUS\G)
Before you run it
Read only.
Used when you see
Replication lagging or stopped
1
See the whole flow →Check replica state, lag and errorsVerify both threads are running and read Last_Error.
Related commands
- SHOW STATUS / VARIABLESServer status & variables
- Show running queriesShow running queries
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store