On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote: > Actually, if you are using 4.1.1 optimize table does get passed to the > slave. This is from the 4.1.1 change log. > > ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now > stored in the binary log and thus replicated to slaves. This logging does > not occur if the optional NO_WRITE_TO_BINLOG keyword (or its alias LOCAL) is > given. Exceptions are that FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH > TABLES WITH READ LOCK are not logged in any case. For a syntax example, see > section 14.5.4.2 FLUSH Syntax.
Ugh. That's the *default*? Gee, that won't surprise anyone, I'm sure... :-( -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
