Snort mailing list archives

Snort, ACID, MySQL performance optimizations


From: Chris Schuler <cschuler () mindleaders com>
Date: Thu, 26 Jul 2001 09:04:00 -0400

I was reading the ACID FAQ, and came across some MySQL performance
optimizations....

Creating indexes
Some of the required indexes are not created in initial MySQL creation
script. The following indexes can be added to significantly improve
performance: 
tcphdr.tcp_sport 
tcphdr.tcp_dport 
acid_ag_alert.ag_sid + acid_ag_alert.ag_cid 

I'm pretty new to MySQL, and I need some help.  Could someone point help me
out in creating these indexes?

thanks,
Chris

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