Re: My Acid/MySQL setup is mega slow.

[Erek Adams <erek () snort org>]

On Thu, 13 Feb 2003, Kenneth G. Arnold wrote:

> I have a sensor and mysql on a Sun Ultra Enterprise 450 with two 400MHz
> processors and 2GB of RAM and I get the same slow results trying to use
> ACID. I have to clean out the entire snort database every week in order to
> get a decent speed when using ACID.

There has been quite a bit of good info posted here about MySQL
speedup/optimizations.  I've snagged some of it [0], that seemed to really
be useful.  I'm sure that the DB junkies have a lot of things that could
speed it up, but I don't think we've been able to take one captive yet.
;-)

Any DB guru's want to really give the schema a "what for?" </austin powers
reference>

-----
Erek Adams

   "When things get weird, the weird turn pro."   H.S. Thompson


[0]     http://www.theadamsfamily.net/~erek/snort/


-------------------------------------------------------
This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your  SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users