Slave Status

Description

The SHOW SLAVE STATUS command provides details on the Replication Slave threads when configured.

Syntax

MySQL/MariaDB

mysql> SHOW SLAVE STATUS;

Drizzle

drizzle> SHOW SLAVE STATUS;

References

MySQL 5.1 Reference Manual - SHOW SLAVE STATUS Syntax

Example

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: localhost
                Master_User: root
                Master_Port: 3306
              Connect_Retry: 3
            Master_Log_File: gbichot-bin.005
        Read_Master_Log_Pos: 79
             Relay_Log_File: gbichot-relay-bin.005
              Relay_Log_Pos: 548
      Relay_Master_Log_File: gbichot-bin.005
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes