Re: Issue with Replication using MySQL 5.7.19 on Windows 2012

[Ankur Tyagi]

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