MariaDB [(none)]> SHOW SLAVE STATUS\G
|
*************************** 1. row ***************************
|
Slave_IO_State: Waiting for master to send event
|
Master_Host: 172.16.0.31
|
Master_User: slave1
|
Master_Port: 3306
|
Connect_Retry: 60
|
Master_Log_File: master-1.000027
|
Read_Master_Log_Pos: 245
|
Relay_Log_File: mysqld-relay-bin.000083
|
Relay_Log_Pos: 18779
|
Relay_Master_Log_File: master-1.000020
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: No
|
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: Query caused different errors on master and slave. Error on master: message (format)='Cannot load from mysql.%s. The table is probably corrupted' error code=1548 ; Error on slave: actual message='no error', error code=0. Default database: 'performance_schema'. Query: 'DROP DATABASE IF EXISTS performance_schema'
|
Skip_Counter: 0
|
Exec_Master_Log_Pos: 18496
|
Relay_Log_Space: 84067
|
Until_Condition: None
|
Until_Log_File:
|
Until_Log_Pos: 0
|
Master_SSL_Allowed: No
|
Master_SSL_CA_File:
|
Master_SSL_CA_Path:
|
Master_SSL_Cert:
|
Master_SSL_Cipher:
|
Master_SSL_Key:
|
Seconds_Behind_Master: NULL
|
Master_SSL_Verify_Server_Cert: No
|
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 0
|
Last_SQL_Error: Query caused different errors on master and slave. Error on master: message (format)='Cannot load from mysql.%s. The table is probably corrupted' error code=1548 ; Error on slave: actual message='no error', error code=0. Default database: 'performance_schema'. Query: 'DROP DATABASE IF EXISTS performance_schema'
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 2
|
1 row in set (0.00 sec)
|