[ale] Any MySQL Experts around?
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.
More information about the Ale