Re: [Fwd: Limits to what ACID can handle?]

["A.L.Lambert" <max () xjack org>]

> Hi ppl,
>
> this was on Focus-ids list regarding ACID - is it true that mysql is
> not able to handle big databases? (>1mln records)

        It'll handle it... just extremely slowly... at my last job, I had
it (ACID + MySQL) running on a quad Xeon (700mhz/2meg L1 cache CPU's),
with 2 gigs of RAM, and a nice fast RAID aray, and even with all that
horsepower, once the DB got into that million+ size, it would take about
30 seconds for simple queries, and seemingly forever (4-8 minutes) when
doing complex queries.  I quit using it because it was too slow and
cumbersome, and took to grepping through the syslogs, and pulling packet
dumps from libpcap files.  I was going to try again with Postgresql and
see if it performed any better, but company went under, and never got the
chance.

-- A.L.Lambert
------------------------------------------------------------------------
Everything should be made as simple as possible, but not simpler.
        -Einstein
------------------------------------------------------------------------


_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users