Re: ACID/MySql DB performance

[Erick Mechler <emechler () techometer net>]

:: I just followed one of the faqs on the optimizations and performance.  
:: 
:: http://www.andrew.cmu.edu/~rdanyliw/snort/acid_faq.html#faq_b10

BTW, the information the ACID FAQ, B-10 regarding the indexes is out of
date.  All three of these indexes are created by default now upon
installation.  The tcphdr indexes have been in the source tree since the
inital import of snort/contrib/create_mysql, and the acid_ag_alert index
was imported in v1.2 of create_acid_tbls_mysql.sql (back on Mon Apr 30
17:43:32 2001 UTC).

Optimizing your tables on a regular basis (if you do a lot of deletes) is 
still good practice, however.

Roman, perhaps the information in the ACID FAQ, B-10  could be updated to 
reflect this?

Thanks - Erick


-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
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