[ale] Any MySQL Experts around?

Jonathan Glass jonathan.glass at ibb.gatech.edu
Mon Feb 16 09:04:06 EST 2004


What about PostGreSQL?

Jonathan

On Mon, 2004-02-16 at 09:19, J.M. Taylor wrote:
> Jim,
> 
> Obviously, if he had said Oracle or DB2 (or even Informix) I would not 
> have posted what I did.
> 
> MySQL cannot handle such things.
> 
> jenn
> 
> 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
> > http://www.ale.org/mailman/listinfo/ale
> > 
> > 
-- 
Jonathan Glass
Systems Support Specialist II
Institute for Bioengineering & Bioscience
Georgia Institute of Technology
Email: jonathan.glass at ibb.gatech.edu
Office: 404-385-0127
Fax: 404-894-2291



More information about the Ale mailing list