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" flag to optimize.
>
> http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html
I just noticed that this is 4.1.1 and above. Older versions do not
replicate OPTIMIZE.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
