Snort mailing list archives
Re: [Fwd: Limits to what ACID can handle?]
From: "A.L.Lambert" <max () xjack org>
Date: Mon, 11 Jun 2001 15:18:39 -0500 (CDT)
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
Current thread:
- [Fwd: Limits to what ACID can handle?] Vitaly Osipov (Jun 11)
- Re: [Fwd: Limits to what ACID can handle?] A.L.Lambert (Jun 11)