MySQL Forums
Forum List  »  Replication

Re: mysql-relay-binlog is not purge in master
Posted by: Will Khoo
Date: April 29, 2021 07:52PM

I don't really see we have lag from slave, not sure if i understand your question. below is the slave status result.

*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: AUSPWKWAPP307.AUS.AMER.DELL.COM
Master_User: replicat
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysqlBinlog.004871
Read_Master_Log_Pos: 39188385
Relay_Log_File: mysql-relay-binlog.009709
Relay_Log_Pos: 39188602
Relay_Master_Log_File: mysqlBinlog.004871
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: fedexdb.hostnames,didb.settings
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 39188385
Relay_Log_Space: 39188861
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: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 0e945c71-0b58-11eb-a4de-005056b410e7
Master_Info_File: D:\Kewill_MysqlData\binlogs\mysql-master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql-relay-binlog is not purge in master
108
April 29, 2021 07:52PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.