Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Dan Nelson
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.

Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Dan Nelson
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

Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Jeremy Zawodny
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.

RE: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Donny Simonton
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

Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Jim
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

Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Jeremy Zawodny
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: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Dan Nelson
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

RE: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Donny Simonton
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

RE: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Donny Simonton
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

Re: OPTIMIZE TABLE and mySQL replication

2004-05-14 Thread Jeremy Zawodny
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.