List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:May 14 2004 7:45pm
Subject:Re: OPTIMIZE TABLE and mySQL replication
View as plain text  
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
> Hi List,
> 
> 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?

It does not.  The command doesn't replicate.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/
Thread
OPTIMIZE TABLE and mySQL replicationJim14 May
  • Re: OPTIMIZE TABLE and mySQL replicationDan Nelson14 May
    • Re: OPTIMIZE TABLE and mySQL replicationDan Nelson14 May
  • Re: OPTIMIZE TABLE and mySQL replicationJeremy Zawodny14 May
    • RE: OPTIMIZE TABLE and mySQL replicationDonny Simonton14 May
    • Re: OPTIMIZE TABLE and mySQL replicationJim14 May
Re: OPTIMIZE TABLE and mySQL replicationJeremy Zawodny14 May
  • Re: OPTIMIZE TABLE and mySQL replicationDan Nelson14 May
    • Re: OPTIMIZE TABLE and mySQL replicationJeremy Zawodny14 May
  • RE: OPTIMIZE TABLE and mySQL replicationDonny Simonton14 May
  • RE: OPTIMIZE TABLE and mySQL replicationDonny Simonton14 May