Yes. > -----Original Message----- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Friday, May 14, 2004 4:26 PM > To: Donny Simonton > Cc: [EMAIL PROTECTED]; 'Jim' > Subject: Re: OPTIMIZE TABLE and mySQL replication > > 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]
