List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 14 2002 8:36pm
Subject:Re: Temporary tables in binary logs
View as plain text  
At 16:33 -0400 8/14/02, Michael McClennen wrote:
>I just noticed that creations and deletions of temporary tables are
>recorded in the MySQL binary log.  My question is: during replication,
>are these transmitted and replayed on the slave servers?  If so, could
>someone explain to me why?  This would seem to be useless, since the
>temporary tables are accessible only to the thread that created them.

What if you update a non-temporary table based on the contents of
a temporary table?

>Also if so, is there a way to turn this off?
>   -- Michael McClennen

Temporary tables in binary logsMichael McClennen15 Aug
  • Re: Temporary tables in binary logsPaul DuBois15 Aug