Hi Eric,
On Jun 9, 2008, at 6:24 PM, Eric Bergen wrote:
> I know it's the default. I'm just curious what the benefit of writing
> things like flush tables to the log is. It seems like it would cause
> more problems than it solves (does it solve any?).
FLUSH TABLES needs to be replicated for dealing with MERGE tables in
replication. For example, if you try to drop a MyISAM table that is
part of a MERGE on windows, it will give an error unless it has been
FLUSH TABLE'd first. So you need to replicate the flush tables and
then the drop table. It is still possible to get a race condition
which results in the error, but helps reduce the chance of it by quite
a bit.
Regards,
Harrison
--
Harrison C. Fisk, MySQL Staff Support Engineer
MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/
