List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 14 2004 7:28pm
Subject:Re: OPTIMIZE TABLE and mySQL replication
View as plain text  
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
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