maria-developers team mailing list archive
Mailing list archive
Re: GTID and Optimize, Analyze etc
On 10/03/17 16:02, Peter Mclarty wrote:
> 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).