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:
Subject
Views
Written By
Posted
709
April 29, 2021 12:36AM
336
April 29, 2021 10:39AM
334
April 29, 2021 06:27PM
332
April 29, 2021 07:49PM
Re: mysql-relay-binlog is not purge in master
394
April 29, 2021 07:52PM
391
April 30, 2021 06:05PM
Sorry, you can't reply to this topic. It has been closed.
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.