[ale] Any MySQL Experts around?
jtaylor at onlinea.com
Mon Feb 16 08:59:46 EST 2004
Obviously, if he had said Oracle or DB2 (or even Informix) I would not
have posted what I did.
MySQL cannot handle such things.
On Mon, 16 Feb 2004, Jim Popovitch wrote:
> 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.
> Ale mailing list
> Ale at ale.org
Systems Analyst, CIS
Armstrong Atlantic State University
taylorje at mail.armstrong.edu
More information about the Ale