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