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.
On 11/29/09 8:39 AM, "Johan De Meersman" <vegivamp@stripped> wrote:
> 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
>> INDEX INTO CACHE statements from its --init-file?
>> And if a master mysql restarts, would the slave execute CACHE INDEX and
>> INDEX INTO CACHE statements the master reads from its --init-file and
>> to the big-log?
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1