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.
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 LOCAL
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.
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 OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE
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
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
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 FLUSH
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 TABLE and mySQL replication
On Fri
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:26:28PM -0500, Donny Simonton wrote:
Actually
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 change log.
10 matches
Mail list logo