running and stable with
all slaves replicating cleanly.
--
++---+---+
| Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] |
++---+---+
porary 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.
>
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:
i have replication going between 2 boxes. the master crashed a few days
ago, and this morning i noticed that the slaves slave thread errored
out. the binary log and offset had changed on the master and the slave
couldn't sync up. i got the slave up and running again by changing the
log file and