RE: optimizing MySQL for Snort

[Steve Halligan <agent33 () geeksquad com>]

See Items B10 and C9 of the ACID FAQ.  They both contain ways to speed up
your database queries.  If anyone has any other optimizations, please submit
them to be added to this FAQ.
http://www.andrew.cmu.edu/~rdanyliw/snort/acid_faq.html

> Alternately, creating indexes can lead to a considerable performance 
>
> improvement - I used the following SQL statements to get orders of 
>
> magnitude improvements in snortreport (this is now 
> create_indexes.sql in 
>
> snortreport-1.1) at the expense of slightly lower insert performance 
>
> (this wasn't an issue for us; if it matters to you, you 
> should probably 
>
> consider using barnyard so that database activity doesn't 
> affect snort).

_______________________________________________
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