[ale] Any MySQL Experts around?

Jim Popovitch jimpop at yahoo.com
Mon Feb 16 05:32:31 EST 2004

On Sun, 2004-02-15 at 12:12, J.M. Taylor wrote:
> I would strongly urge you *not* to store your log files in any relational 
> database.  There's just no reason to do it...

I know of several Fortune 100 companies that do this.  The obvious reason 
is for reporting purposes.  If I put all my syslog entries into a database, 
that can handle them, then I can easily produce reports that show me 
valuable data.  Imagine having 1000 servers and wanting to know the top 10 
systems that had more than 2 root login failures per month.  Try doing that 
with grep/sed/awk :)

Oracle and DB2 can scale to hundreds of millions of rows and still be
easily queried.  The trick is to use partitioning and to know in advance
how you will need your indexes setup.

-Jim P.

More information about the Ale mailing list