MySQL Forums
Forum List  »  Replication

Re: Issue with Replication using MySQL 5.7.19 on Windows 2012
Posted by: Ankur Tyagi
Date: June 18, 2019 11:36AM

Thanks Peter for looking into this, Apologies for responding late.
Just to let you know I have very limited exposure in mysql administration tasks. Can you please help how I can find out or validate these configurations in my environment.
Have you proved that the dump brought the slave perfectly up to date?
How big is the relay log? Is the relay pos correct?

show variable like '%timeout%';

Variable_name Value
connect_timeout 10
delayed_insert_timeout 300
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 28800
lock_wait_timeout 31536000
net_read_timeout 30
net_write_timeout 60
rpl_stop_slave_timeout 31536000
slave_net_timeout 60
wait_timeout 28800

Options: ReplyQuote

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.