So I gather you are creating a table, and doing some work in it, but even though it isn't declared 'temporary' it really is and you don't want it replicated?
If this is the case you can create the table in a separate database, and in your mysql configuration tell the binary logging to exclude that database. Then anything in that specific database won't get replicated, I believe you can only do this exclusion on the database level, not per table. But you can perform all your queries across databases just fine. On Thu, 2004-10-21 at 11:24 -0700, Gary Richardson wrote: > Hey, > > Is there a way to tell the slave to not execute a query without > ignoring tables or databases? > > There are a bunch of queries that happen on the master for statistical > purposes that don't use temp tables and generate large amounts of > data. These queries don't need to run on the slaves and in fact slow > it down quite a bit. > > I've tried hunting around the online docs, but I can't seem to find > anything. For some reason I thought there was some sort of comment > that I could put infront of my query to accomplish this. > > Thanks. > -- John A. McCaskey Software Development Engineer Klir Technologies, Inc. [EMAIL PROTECTED] 206.902.2027 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
