List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 29 2009 1:39pm
Subject:Re: Is LOAD INDEX INTO CACHE replicated?
View as plain text  
They're not data modification statements, so no, they're not replicated.

On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster <fsb@stripped> wrote:

> Are SQL statements like CACHE INDEX or LOAD INDEX INTO CACHE replicated?
>
> If so, is there a way to prevent that replication?
>
> If a slave mysqld restarts, wouldn't it need to execute CACHE INDEX and
> LOAD
> INDEX INTO CACHE statements from its --init-file?
>
> And if a master mysql restarts, would the slave execute CACHE INDEX and
> LOAD
> INDEX INTO CACHE statements the master reads from its --init-file and
> writes
> to the big-log?
>
> tom
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Is LOAD INDEX INTO CACHE replicated?Tom Worster29 Nov
  • Re: Is LOAD INDEX INTO CACHE replicated?Johan De Meersman29 Nov
    • Re: Is LOAD INDEX INTO CACHE replicated?Tom Worster30 Nov