Baron Schwartz wrote on Thu, Sep 20, 2007 at 07:46:44PM -0400: > 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.
i should have been more clear. what i meant is that the create temporary table query is sent to the slave, and the table is created on the slave. this much i know from slaves dying then not restarting due to the missing temporary table. my current problem is my slaves are creating myisam temporary tables on disk and alot of them. which eventualy results in mysqld no longer being able to open any files with ERROR: 1 Can't create/write to file '/sql/tmp/#sql17fb_2f_0.frm' (Errcode: 24) 070919 11:06:41 Slave: Error 'Can't create/write to file '/sql/tmp/#sql17fb_2f_0.frm' (Errcode: 24)' on query 'CREATE TEMPORARY TABLE aggregate ( along with messages like 070919 22:04:03 Error in accept: Too many open files what brought this all on was a switch to new hardware(completely new server) for the master. kept the same version of mysql on the new hardware, slaves didn't change at all, other then resetting up replication from scratch with the data snapshot from the current master after hardware swap. this didn't happen on the slaves prior to the hardware swap. i don't understand why the temp tables are being written to disk now, when they weren't in the past. > > 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] > >> > >> > > > > > -- +----------------+-------------------------------+---------------------------+ | Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] | +----------------+-------------------------------+---------------------------+ | "Ubuntu" -- an African word, meaning "Slackware is too hard for me" | | "Mandriva" -- a French word, meaning "Slackware is too hard for me" | | "Fedora" -- an American word, meaning "Slackware is too hard for me" | | -- seen on alt.os.linux.slackware | +----------------------------------------------------------------------------+ "There was a boy called Eustace Clarence Scrubb, and he almost deserved it." -- C. S. Lewis, The Chronicles of Narnia
pgpeqUn2WliIi.pgp
Description: PGP signature