Re: Turning off logging for certain download queries
Jeremy, I did test it and couldn't get it to work one way or the otherHowever, as it turns out, the '--binlog-ignore-db' option will work for me. Thanks for all your help!! Phil At 11:03 AM 7/10/2001 -0700, you wrote: >On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote: > > At 03:01 PM 7/9/2001 -0700, you wrote: > > >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: > > > > > We do a few large daily and monthly downloads from an Oracle database > > > > > server. Is there a way to exclude these specific queries from the > > > > > update/binary log?? > > > > > > > > If the queries only affect one table or database, use the > > > > replication ignore options listed here: > > > > http://www.mysql.com/doc/R/e/Replication_Options.html > > > > > >Better yet, check this page: > > > > > > http://www.mysql.com/doc/R/e/Replication_SQL.html > > > > > >And look at "SET SQL_LOG_BIN=0" > > > > Does this turn off logging for everything (all other connections) or > > only for the current connection?? > >Hmm. Good point. I hadn't thought about that. And the manual >doesn't say one way or the other, so I assume it's a global setting. >This might not be what you want aferall. > >But it would be useful to be able to do this on a per connection >basis. Perhaps some testing is in order. > >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 > >MySQL 3.23.29: up 24 days, processed 183,699,039 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Turning off logging for certain download queries
On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote: > At 03:01 PM 7/9/2001 -0700, you wrote: > >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: > > > > We do a few large daily and monthly downloads from an Oracle database > > > > server. Is there a way to exclude these specific queries from the > > > > update/binary log?? > > > > > > If the queries only affect one table or database, use the > > > replication ignore options listed here: > > > http://www.mysql.com/doc/R/e/Replication_Options.html > > > >Better yet, check this page: > > > > http://www.mysql.com/doc/R/e/Replication_SQL.html > > > >And look at "SET SQL_LOG_BIN=0" > > Does this turn off logging for everything (all other connections) or > only for the current connection?? Hmm. Good point. I hadn't thought about that. And the manual doesn't say one way or the other, so I assume it's a global setting. This might not be what you want aferall. But it would be useful to be able to do this on a per connection basis. Perhaps some testing is in order. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 24 days, processed 183,699,039 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Turning off logging for certain download queries
At 03:01 PM 7/9/2001 -0700, you wrote: >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: > > > We do a few large daily and monthly downloads from an Oracle database > > > server. Is there a way to exclude these specific queries from the > > > update/binary log?? > > > > If the queries only affect one table or database, use the > > replication ignore options listed here: > > http://www.mysql.com/doc/R/e/Replication_Options.html > >Better yet, check this page: > > http://www.mysql.com/doc/R/e/Replication_SQL.html > >And look at "SET SQL_LOG_BIN=0" Does this turn off logging for everything (all other connections) or only for the current connection?? >Jeremy >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 > >MySQL 3.23.29: up 23 days, processed 177,648,797 queries (87/sec. avg) > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Turning off logging for certain download queries
On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: > > We do a few large daily and monthly downloads from an Oracle database > > server. Is there a way to exclude these specific queries from the > > update/binary log?? > > If the queries only affect one table or database, use the > replication ignore options listed here: > http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at "SET SQL_LOG_BIN=0" Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 177,648,797 queries (87/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Turning off logging for certain download queries
> We do a few large daily and monthly downloads from an Oracle database > server. Is there a way to exclude these specific queries from the > update/binary log?? If the queries only affect one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turning off logging for certain download queries
We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php