Snort mailing list archives

AICD_FAQ--Performance tuning


From: Steve Halligan <agent33 () geeksquad com>
Date: Fri, 2 Nov 2001 09:57:02 -0600

---------------ACID FAQ------------------
Q:  Acid is reeeeeaaaaaalllly slow opening pages/deleting || archiving
alerts, what can I do?

A:      1)  Update to the newest version of ADODB which can be found at
http://php.weblogs.com/adodb
        2)  Turn off auto-updating of the event cache. (See C-7 of this FAQ)
        3)  Try switching from a standard to a persistant database
connection (or vice-versa).  See the db_connect_method varible in
acid_conf.php.
        4)  If you are running PostgreSQL or MySQL follow the optimization
steps in sections B-9 and B-10 of this FAQ.
        5)  If you are running MySQL and have lots of RAM, check out the
"Tuning Server Parameters" section of the MySQL documentation at
http://www.mysql.com/doc/S/e/Server_parameters.html.  For those of us with
short attention spans, try starting MySql (or edit the safemysqld script)
with the following command line: 
                shell> safe_mysqld -O key_buffer=64M -O table_cache=256 -O
sort_buffer=4M -O record_buffer=1M &
        6)  If you are running PostgreSQL, check out
http://www.ca.postgresql.org/docs/momjian/hw_performance/ for hints on
hardware/server config optimization.

---------------ACID FAQ------------------

_______________________________________________
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


Current thread: