This was exactly what I was looking for :) Too bad you need to be SUPER to do it :(
Thanks. On Thu, 21 Oct 2004 12:44:11 -0700, Sanjeev Sagar <[EMAIL PROTECTED]> wrote: > Try SET SQL_LOG_BIN=0 before you run your queires on master. This will be valid for > that connection only. > > > > > -----Original Message----- > From: Gary Richardson [mailto:[EMAIL PROTECTED] > Sent: Thu 10/21/2004 11:24 AM > To: Mysql General (E-mail) > Subject: Ignore a single query in replication > > 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. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
