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 et al, thanks for the replies.
So (and here I expose my newbness) can the OPTIMIZE TABLE be run on the slave database tables, which are read-only?
This is on version 4.0.16 of the server.
Jim
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
