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

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

-- 
	Dan Nelson
	dnelson@stripped