Re: temporary tables on disk?

2007-09-21 Thread Chris Scheller
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

Re: temporary tables on disk?

2007-09-21 Thread Chris Scheller
replicating cleanly. -- ++---+---+ | Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] | ++---+---+ | Ubuntu -- an African word, meaning

temporary tables on disk?

2007-09-20 Thread Chris Scheller
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

slave out of sync

2005-04-08 Thread Chris Scheller
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