Snort mailing list archives
Re: My Acid/MySQL setup is mega slow.
From: "Kenneth G. Arnold" <bkarnold () cbu edu>
Date: Thu, 13 Feb 2003 17:14:58 -0600
I have a sensor and mysql on a Sun Ultra Enterprise 450 with two 400MHz processors and 2GB of RAM and I get the same slow results trying to use ACID. I have to clean out the entire snort database every week in order to get a decent speed when using ACID.
Ken Arnold At 02:44 PM 2/13/03 -0700, Ken Gunderson wrote:
On Thursday 13 February 2003 01:38 pm, Aaron The Young wrote: > Hi, > > I have two Snort sensors setup and both are on PII-333 with 256MB > machines running Debian 3.0. On one sensor I have MySQL and the > sensor and the other JUST has the sensor and feeds the sensor/sql DB > host. > > Am I foolish to think I'd get adequate performance out of this > level of hardware? > > The real delay is seen when entering ACID. When I first started > this project, it took about 20 seconds for ACID to give me a > page when I logged in, now it takes minutes and seems to get > longer and longer as I load up my SQL database with data. > > If I need to get a more power SQL server, I'd like confirmation. > If it's just a matter of tuning, what can I do? Finally, is there > an easy SQL statement to drop the last 30 days of data from my DB? > > Thanks in advance. > > Aaron have you done any performance tweaking of mysql? see mysql docs. you may also want to try throwing some more ram on your db machine. imho, the 256 should be adequate for the sensor only boxen, but what is top telling you? -- Best regards, Ken Gunderson PGP Key-- 9F5179FD "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin, Historical Review of Pennsylvania. ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ 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
------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ 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:
- My Acid/MySQL setup is mega slow. Aaron The Young (Feb 13)
- Re: My Acid/MySQL setup is mega slow. Ken Gunderson (Feb 13)
- Re: My Acid/MySQL setup is mega slow. Kenneth G. Arnold (Feb 13)
- Re: My Acid/MySQL setup is mega slow. Erick Mechler (Feb 13)
- Re: My Acid/MySQL setup is mega slow. Erek Adams (Feb 13)
- Re: My Acid/MySQL setup is mega slow. acyoung (Feb 14)
- Re: My Acid/MySQL setup is mega slow. Ken Gunderson (Feb 14)
- Re: My Acid/MySQL setup is mega slow. Kenneth G. Arnold (Feb 13)
- Re: My Acid/MySQL setup is mega slow. Ken Gunderson (Feb 13)