Real time logging to sql database

Chris Trudeau chris at TRUDEAU.ORG
Mon Dec 22 21:16:41 GMT 2003

Yep...exactly the design that Julian/Steve had in mind (I assume).

The MailWatch package uses temp files as well I IS however a
great solution...


----- Original Message -----
From: "David H." <dh at UPTIME.AT>
Sent: Monday, December 22, 2003 4:09 PM
Subject: Re: Real time logging to sql database

> Hash: RIPEMD160
> Paul Hamilton wrote:
> > Hi all,
> Hello.
> >
> > Is there anybody using real time logging for Mailscanner to a
> > sql database per message, rather than generating temporary
> > files and flushing every restart?
> >
> Just some general thought. I wonder how secure this is and what kind of
> performance hit one has to take. Theorethically, if I wish to do this
> "securely" each log message has to be its own transaction. Thus a
> singular INSERT results ina full transaction within the database. Now,
> when I imagine I have a fiarly busy MailServer with, let's say, 0.5 or 1
> message per second, that might nag on the database a whole lot when I
> log _directly_ into the Daemon.
> Maybe it is indeed faster to simply write out SQL INSERT statements into
> a file, to the disc and sync this file into the database every 15 or 30
> minutes. This could be done in a single transaction then.
> But then again, I am by far no Database guru.
> - -d
> Version: GnuPG v1.2.3 (Darwin)
> iD8DBQE/5112PMoaMn4kKR4RA9mbAJ4rOPYzjnGcL9kus9eT1poJ/ZSwUQCeN57j
> 9L4MUB1vnC6x/zh6nRxBtFs=
> =tSih

More information about the MailScanner mailing list