mysql 查看主从_【查看mysql主从状态】

mysql \ gt;

*************************** 1.行******************** *******

Slave_IO_State:等待主机发送事件

Master_Host:master1

Master_User:root

主端口:3306

Connect_Retry:60

Master_Log_File:mysql-bin.000004

Read_Master_Log_Pos:931

Relay_Log_File:slave1-relay-bin.000056

Relay_Log_Pos:950

Relay_Master_Log_File:mysql-bin.000004

Slave_IO_Running:是

Slave_SQL_Running:是

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno:0

Last_Error:

跳过计数器:0

Exec_Master_Log_Pos:931

Relay_Log_Space:1365

直到条件:无

直到日志文件:

直到日志记录位置:0

Master_SSL_Allowed:否

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master:0

Master_SSL_Verify_Server_Cert:否

Last_IO_Errno:0

Last_IO_Error:

Last_SQL_Errno:0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:0