Temporary tables in binary logs

2002-08-14 Thread Michael McClennen

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.

Also if so, is there a way to turn this off?

  -- Michael McClennen


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Temporary tables in binary logs

2002-08-14 Thread Paul DuBois

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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php