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). _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
