Re: How to log some queries and not others

2005-02-10 Thread George Chelidze
Dear Paul, Paul DuBois wrote: At 19:52 +0300 2/9/05, George Chelidze wrote: Hello, I have the following problem: I have a table with a blob field and turned on query logging. I'd like to log every query except inserts into table with a blob field because my log files grow very fast and I don't l

Re: How to log some queries and not others

2005-02-09 Thread Paul DuBois
At 19:52 +0300 2/9/05, George Chelidze wrote: Hello, I have the following problem: I have a table with a blob field and turned on query logging. I'd like to log every query except inserts into table with a blob field because my log files grow very fast and I don't like to see binary data in my l

Re: How to log some queries and not others

2005-02-09 Thread DreamWerx
Cron hack? have a console running: tail -f hostname.log | grep "tablename" > filter.log -or- tail -f hostname.log | grep -v "insert into blobtablename" > filter.log > then have a cronjob every X minutes running: echo "" > hostname.log To truncate the full querylog from getting too big? No