From: Dan Nelson
Date: May 14 2004 7:30pm
Subject: Re: OPTIMIZE TABLE and mySQL replication
List-Archive: http://lists.mysql.com/mysql/165461
Message-Id: <20040514193040.GA81440@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 14), Dan Nelson said:
> In the last episode (May 14), Jim said:
> > What are some issues relating to using OPTIMIZE TABLE and
> > replication?  Does running OPTIMIZE TABLE on a master DB cause the
> > optimizations to be passed on to the slaves?
> 
> Yes, unless you add the "LOCAL" flag to optimize.
> 
> http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html

I just noticed that this is 4.1.1 and above.  Older versions do not
replicate OPTIMIZE.

-- 
	Dan Nelson
	dnelson@stripped