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] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
