From: Duane Hill (d.hillyournetplus.com)
Date: Tue Jul 10 2007 - 22:33:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Tue, 10 Jul 2007 at 19:59 -0700, chandler.listschapman.edu confabulated:

> Hamilton Vera wrote:
>> Howdy!
>>
>> Get used to code in Perl || Python and check out the syslog-ng, it allows
>> you to "save"
>> the logs in a database ( such as MySQL ), so it´d be easier to handle the
>> info you want.
>>
>>
> On a semi related note, how does that treat compression? Our mailservers are
> generating nearly half a gig of data a day at the moment, before it's gzipped
> down to a tenth that size. Does MySQL have some form of compression built
> in, or am I going to need to invest in a RAID array to keep the data for more
> than a week or two?
>
> And man, do I ever hate coding... :-)

I haven't looked at this yet. MySQL has an ARCHIVE storage engine:

   http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html

-----
  _|_
(_| |

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]