row ***********
03
Slave_IO_State: Waiting for mas
04
Master_Host: 192.168.0.102
05
Master_User: replication
06
Master_Port: 3306
07
Connect_Retry: 60
08
Master_Log_File: mysql-bin.00000
09
Read_Master_Log_Pos: 120
10
Relay_Log_File: YZ-relay-bin.00
11
Relay_Log_Pos: 266
12
Relay_Master_Log_File: mysql-bin.00000
13
Slave_IO_Running: Yes #必须为yes
14
Slave_SQL_Running: Yes #必须为yes
15
Replicate_Do_DB: webportal
16
Replicate_Ignore_DB:
17
Replicate_Do_Table:
18
Replicate_Ignore_Table:
19
Replicate_Wild_Do_Table:
20
Replicate_Wild_Ignore_Table:
21
Last_Errno: 0
22
Last_Error:
23
Skip_Counter: 0
24
Exec_Master_Log_Pos: 120
25
Relay_Log_Space: 419
26
Until_Condition: None
27
Until_Log_File:
28
Until_Log_Pos: 0
29
Master_SSL_Allowed: No
30
Master_SSL_CA_File:
31
Master_SSL_CA_Path:
32
Master_SSL_Cert:
33
Master_SSL_Cipher:
34
Master_SSL_Key:
35
Seconds_Behind_Master: 0
36
Master_SSL_Verify_Server_Cert: No
37
Last_IO_Errno: 0
38
Last_IO_Error:
39
Last_SQL_Errno: 0
40
Last_SQL_Error:
41
Replicate_Ignore_Server_Ids:
42
Master_Server_Id: 1
43
1 row in set (0.00 sec)
注：Slave_IO及Slave_SQL进程必须正常运行，即YES状态，否则都是错误的状态(如：其中一个NO均属错误)。