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 10
for more information on setting server variables at startup. You can
set some of these variables with the SET
statement. You can adjust others for particular tables with the
ALTER TABLE
statement. You can reset some of the
logfile variables with the RESET MASTER
and
RESET
SLAVE
statements.
Get MySQL in a Nutshell 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.