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" <vegiv...@tuxera.be> wrote: > 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 >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
