From: Johan De Meersman Date: November 29 2009 1:39pm Subject: Re: Is LOAD INDEX INTO CACHE replicated? List-Archive: http://lists.mysql.com/mysql/219533 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6480e088aed1e047982a81c --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@stripped > > --0016e6480e088aed1e047982a81c--