← Back to team overview

maria-developers team mailing list archive

GTID and Optimize, Analyze etc

 

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.


Follow ups