Name
SHOW SLAVE STATUS
Synopsis
SHOW SLAVE STATUS
This statement displays information on the slave thread. Here is an example of this statement and its results:
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: 5 Master_Log_File: log-bin.000154 Read_Master_Log_Pos: 159 Relay_Log_File: log-relay-bin.154 Relay_Log_Pos: 694 Relay_Master_Log_File: log-bin.154 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 159 Relay_Log_Space: 694 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: ssl_ca.dat Master_SSL_CA_Path: /data/mysql/ssl_ca Master_SSL_Cert: ssl_cert.dat Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 3
You can set some of these values at startup with the MySQL
server daemon (mysqld). See Chapter 15 for more information on setting server
variables at startup. You can also set some of these variables with
the SET
statement, and you can adjust others for
particular tables with the ALTER TABLE
statement.
You can reset some of the log file variables with the RESET MASTER and RESET SLAVE
statements.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.