ACID/MySql DB performance

["McPheeters, Scott" <smcpheeters () fnms-indy com>]

I am seeing a lot of messages about mySql DB performance.  I am curious what the general consciences is about how many 
alerts are in your database?

I normally see a pretty big performance change around 100k alerts, at that point the "snap" is gone and the system has 
to think about each page. I am still working on my rules, does it ever end? hehe, so I can run anywhere between 50k and 
300k.

How many alerts do you try to keep your databases at?  
When do you start feeling the performance differences??


ps. my db server is quad xeon 500, 2gig ram, lots of disk.  I have done the extra indexes and I check the tables for 
optimizations.

Scott


-------------------------------------------------------
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