Re: temporary tables on disk?

2007-09-21 Thread Chris Scheller
running and stable with all slaves replicating cleanly. -- ++---+---+ | Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] | ++---+---+

Re: temporary tables on disk?

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

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 archives:

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 and