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?

Not pretty..



On Wed, 09 Feb 2005 19:52:33 +0300, George Chelidze <[EMAIL PROTECTED]> 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 log files, while other logs are very
> informative and important. How can I do that?
> 
> Best Regards,
> --
> George Chelidze
> 
> --
> 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]

Reply via email to