maria-developers team mailing list archive

Thread
Date

Re: GTID and Optimize, Analyze etc

To: Peter Mclarty <peter.mclarty@xxxxxxxxxxxxxxxxxxxxxxx>, MariaDB Developers <maria-developers@xxxxxxxxxxxxxxxxxxx>
From: Daniel Black <daniel.black@xxxxxxxxxxx>
Date: Fri, 10 Mar 2017 16:13:58 +1100
In-reply-to: <CADkafGghAp710fJyg4osdpTWfoXdk=r8Hj2fGfo56qr0qUt=1A@mail.gmail.com>
Organization: IBM
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.7.0


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).

References

GTID and Optimize, Analyze etc
From: Peter Mclarty, 2017-03-10