Snort mailing list archives
Re: AICD_FAQ--Performance tuning
From: roman () danyliw com
Date: Fri, 2 Nov 2001 13:03:37 US/Eastern
Good idea. Added. Any other tuning tips? Anyone? Roman On Fri, 2 Nov 2001, Steve Halligan wrote:
---------------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------------------
--------------------------------------------- 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: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- AICD_FAQ--Performance tuning Steve Halligan (Nov 02)
- <Possible follow-ups>
- Re: AICD_FAQ--Performance tuning roman (Nov 02)