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

Can I set a session variable to block any change

Cheers

--

Cheers
Peter McLarty




Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. 
If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. 
If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.