On Fri, May 14, 2004 at 04:29:29PM -0500, Dan Nelson wrote:
> In the last episode (May 14), Jeremy Zawodny said:
> > 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 chan
Yes.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> On Fri, May 14, 2004 at 03:2
It surprised me at first, but then I was actually happy about it.
Donny
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE
In the last episode (May 14), Jeremy Zawodny said:
> 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 FL
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 re
Jeremy Zawodny wrote:
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
[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 2:46 PM
> To: Jim
> Cc: [EMAIL PROTECTED]
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
> > Hi List,
> >
> > What are some issues relating to using OPTIMI
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.
--
Jerem
In the last episode (May 14), Dan Nelson said:
> 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
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/
10 matches
Mail list logo
