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