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

Check replica state, lag and errorsVerify both threads are running and read Last_Error.

See the whole flow →

Related commands

SHOW STATUS / VARIABLESServer status & variables
Show running queriesShow running queries

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store