2 messages in com.mysql.lists.mysqlRe: Temporary tables in binary logs
FromSent OnAttachments
Michael McClennen14 Aug 2002 13:33 
Paul DuBois14 Aug 2002 13:36 
Subject:Re: Temporary tables in binary logs
From:Paul DuBois (pa@snake.net)
Date:08/14/2002 01:36:36 PM
List:com.mysql.lists.mysql

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