Snort mailing list archives

Re: Over 1 Million records in ACID.....


From: "David E. Gianndrea" <daveg () comsquared com>
Date: Thu, 27 Mar 2003 16:55:23 -0500

Cool!!!!!!


Ghercoias, Catalin wrote:
David,

Thank you so much, although I did not had any /etc/my.cnf file in my system
(don't know why....) I added one with the suggested content by you. Now the
ACID/MySQL process has improved significantly. The changes/additions suggested plus increased values of
'max_script_runtime=1800' in acid_php.conf ; 'max_execution_time=1800'and
memory_limit=128M made a big difference in the performance of the system.

Thank you again, ___________________________ Catalin Ghercoias Web/Security System Administrator Office Phone: +(518) 452-1242 Ext.7435 Fax: (518) 452-4768 Mail: Catalin Ghercoias website: http://www.fye.com

-----Original Message-----
From: David E. Gianndrea [mailto:daveg () comsquared com] Sent: Thursday, March 27, 2003 3:07 PM
To: Ghercoias, Catalin
Cc: 'snort-users () lists sourceforge net'
Subject: Re: [Snort-users] Over 1 Million records in ACID.....


I had the same thing happen to me, but with different rule. I added this to
my /etc/my.cnf file

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
set-variable = table_cache=256
set-variable = key_buffer=64M
set-variable = sort_buffer=4M


Be sure to read the docs for Mysql BEFORE using these. Im not an DBA but it
helped out some with performance of Mysql.



--
David Gianndrea
Senior Network Engineer
Comsquared Systems, Inc.

Web:     www.comsquared.com
Email:   dgianndrea () comsquared com




-------------------------------------------------------
This SF.net email is sponsored by:
The Definitive IT and Networking Event. Be There!
NetWorld+Interop Las Vegas 2003 -- Register today!
http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
_______________________________________________
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: