Michael explained it well, but just to say it a different way, the
temporary table is created as an intermediate step in the table, and is
implicit, not explicit. So it's not "sent" to the slave -- the query is
sent to the slave, and if the query optimizer makes the same decisions
on the slave that it did on the master, the slave will also create a
temporary table during query processing.
Michael Dykman wrote:
Temporary tables only exist for the length of time that the connection
that created them remains connected and are only visible to that
connection. There is no reason to replicate these to a slave at all,
as no client connecting to that slave would ever be able to see them.
- michael dykman
On 9/20/07, Chris Scheller <[EMAIL PROTECTED]> wrote:
according to
http://dev.mysql.com/doc/refman/4.1/en/internal-temporary-tables.html
temporary tables can sometimes be written to disk as myisam. in
replication are these myisam temp tables sent to the slaves as myisam
tables or in memory tables?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
