List:General Discussion« Previous MessageNext Message »
From:Donny Simonton Date:May 14 2004 9:27pm
Subject:RE: OPTIMIZE TABLE and mySQL replication
View as plain text  
It surprised me at first, but then I was actually happy about it.

Donny

> -----Original Message-----
> From: Jeremy Zawodny [mailto:Jeremy@stripped]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: mysql@stripped; 'Jim'
> Subject: Re: OPTIMIZE TABLE and mySQL replication
> 
> On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > Actually, if you are using 4.1.1 optimize table does get passed to the
> > slave.  This is from the 4.1.1 change log.
> >
> > ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are
> now
> > stored in the binary log and thus replicated to slaves. This logging
> does
> > not occur if the optional NO_WRITE_TO_BINLOG keyword (or its alias
> LOCAL) is
> > given. Exceptions are that FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and
> FLUSH
> > TABLES WITH READ LOCK are not logged in any case. For a syntax example,
> see
> > section 14.5.4.2 FLUSH Syntax.
> 
> Ugh.  That's the *default*?
> 
> Gee, that won't surprise anyone, I'm sure...
> 
> :-(
> --
> Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <Jeremy@stripped>  |  http://jeremy.zawodny.com/
> 
> [book] High Performance MySQL -- http://highperformancemysql.com/
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> 


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