Snort mailing list archives
Re: Snort, ACID, MySQL performance optimizations
From: roman () danyliw com
Date: Thu, 26 Jul 2001 09:21:26 US/Eastern
http://www.mysql.com/doc/C/R/CREATE_INDEX.html CREATE INDEX tcp_sport_index ON tcphdr (tcp_sport); CREATE INDEX tcp_dport_index ON tcphdr (tcp_dport); CREATE INDEX acid_ag_alert_sid_cid_index ON acid_ag_alert (ag_sid, ag_cid); cheers, Roman
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
--------------------------------------------- This message was sent using Voicenet WebMail. http://www.voicenet.com/webmail/ _______________________________________________ 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:
- Snort, ACID, MySQL performance optimizations Chris Schuler (Jul 26)
- <Possible follow-ups>
- Re: Snort, ACID, MySQL performance optimizations roman (Jul 26)
- RE: Snort, ACID, MySQL performance optimizations roman (Jul 26)