Is LOAD INDEX INTO CACHE replicated?

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=gcdmg-mysql-2@m.gmane.org

Re: Is LOAD INDEX INTO CACHE replicated?

--0016e6480e088aed1e047982a81c
Content-Type: text/plain; charset=ISO-8859-1

They're not data modification statements, so no, they're not replicated.

On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster 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=vegivamp@tuxera.be
>
>

--0016e6480e088aed1e047982a81c--

Re: Is LOAD INDEX INTO CACHE replicated?

Thank you for the answer. This makes sense.

As such, the questions of preloading the key buffer in a replication system
are probably resolved. I think I can safely put CACHE INDEX and LOAD INDEX
INTO CACHE statements in the --init-file of both masters and slaves.

tom


On 11/29/09 8:39 AM, "Johan De Meersman" wrote:

> They're not data modification statements, so no, they're not replicated.
>
> On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster 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=vegivamp@tuxera.be
>>
>>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org