Re: slow.log by date

2008-11-30 Thread chaim . rieger
Syslog-ng combined with logrotate


--Original Message--
From: Fayland Lam
To: mysql@lists.mysql.com
Subject: slow.log by date
Sent: Nov 30, 2008 18:22

well, our slow.log is pretty huge and say I just want the logs in the 
last week. (tail -n XXX is not good enough)
I'm wondering there is a script (Perl or bash or others) can do this? 
I'm not willing to reinvent the wheel. :)

Thanks.

-- 
Fayland Lam // http://www.fayland.org/ 
Foorum based on Catalyst // http://www.foorumbbs.com/ 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Sent via BlackBerry from T-Mobile

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: slow.log by date

2008-11-30 Thread Fayland Lam

[EMAIL PROTECTED] wrote:

Syslog-ng combined with logrotate
  


well, logrotate is for the coming log. what can we do towards existing 
ones. :)


Thanks.



--Original Message--
From: Fayland Lam
To: mysql@lists.mysql.com
Subject: slow.log by date
Sent: Nov 30, 2008 18:22

well, our slow.log is pretty huge and say I just want the logs in the 
last week. (tail -n XXX is not good enough)
I'm wondering there is a script (Perl or bash or others) can do this? 
I'm not willing to reinvent the wheel. :)


Thanks.

  



--
Fayland Lam // http://www.fayland.org/ 
Foorum based on Catalyst // http://www.foorumbbs.com/ 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: slow.log by date

2008-11-30 Thread chaim . rieger
Write a perl script

Am sure there are some out there

Look at addons for awstats.


--Original Message--
From: Fayland Lam
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: slow.log by date
Sent: Nov 30, 2008 18:37

[EMAIL PROTECTED] wrote:
 Syslog-ng combined with logrotate
   

well, logrotate is for the coming log. what can we do towards existing 
ones. :)

Thanks.


 --Original Message--
 From: Fayland Lam
 To: mysql@lists.mysql.com
 Subject: slow.log by date
 Sent: Nov 30, 2008 18:22

 well, our slow.log is pretty huge and say I just want the logs in the 
 last week. (tail -n XXX is not good enough)
 I'm wondering there is a script (Perl or bash or others) can do this? 
 I'm not willing to reinvent the wheel. :)

 Thanks.

   


-- 
Fayland Lam // http://www.fayland.org/ 
Foorum based on Catalyst // http://www.foorumbbs.com/ 



Sent via BlackBerry from T-Mobile

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]