RE: Syslog and MySQL

["Bloem, M. (Matthijs)" <M Bloem agi rws minvenw nl>]

> -----Oorspronkelijk bericht-----
> Van: Mike Kercher [mailto:mike CamaroSS net]
> Verzonden: donderdag 9 september 2004 15:16
> Aan: 'Discussion of Red Hat Enterprise Linux 3 (Taroon)'
> Onderwerp: RE: Syslog and MySQL
> 
> 
> Bloem, M. (Matthijs) wrote:
> > Ok,
> > 
> > I may be dutch, but I know google...
> > What I really would like to know is if there is anybody who has a
> > similar setup in a production environment and can tell me something
> > about performance and pitfalls with an implementation.  
> > 
> > Matthijs
> > 
> > -----Oorspronkelijk bericht-----
> > Van: Mike Kercher [mailto:mike CamaroSS net]
> > Verzonden: donderdag 9 september 2004 14:50
> > Aan: 'Discussion of Red Hat Enterprise Linux 3 (Taroon)'
> > Onderwerp: RE: Syslog and MySQL
> > 
> > 
> > Bloem, M. (Matthijs) wrote:
> >> Hi,
> >> 
> >> I wanted to know if anyone has any experience with logging 
> to a MySQL
> >> database. So I want the syslog daemon sent the output to an MySQL
> >> database instead of /var/log/messages.
> >> Any experience or ideas woul be nice
> >> 
> >> kind regards,
> >> 
> >> Matthijs Bloem
> >> 
> > 
> 
> Reply wasn't meant as a barb at your nationality.  If you 
> were to implement
> mysql logging, how would you go about "log rotation"?  Seems 
> to me that your
> database would grow and grow unless you were to delete rows 
> based on date or
> something.
> 
> Mike
> 
> 
> --
> Taroon-list mailing list
> Taroon-list redhat com
> http://www.redhat.com/mailman/listinfo/taroon-list
> 

Because the log entries all have date stamps, I was planning to do a daily
(or weekly) query for entries older then a day(week). Put this in a script
which is executed by the crontab.
My major concern is performance, I am going to implement this on a
postfix-mailserver with virus and spam filtering. Does writing to a database
take up much more performance then writing to a text file?

Matthijs

Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************