10 Mar
2017
10 Mar
'17
6:13 a.m.
On 10/03/17 16:02, Peter Mclarty wrote:
Hi
I have some very large tables and I would like to give them a cleanup. If I run OPTIMIZE and ANALYZE on a slave does that affect the GTID of that slave and cause me to eventually get the dreaded Slave has diverged too far from the master type error
ANALYZE NO_WRITE_TO_BINLOG ... OPTIMIZE NO_WRITE_TO_BINLOG ...
Can I set a session variable to block any change
SET SESSION SQL_LOG_BIN=0 (for the same effect).