Re: OPTIMIZE TABLE and mySQL replication

[Dan Nelson]

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