Snort mailing list archives
RE: BASE performance
From: "Michael Steele" <michaels () winsnort com>
Date: Mon, 21 Feb 2005 18:19:15 -0800
Can you tell us what optimizing the MySQL database might be, and the procedure? I do understand that when the alerts are deleted, at least with ACID there are some remains of the alerts left behind. Can these be cleaned, and if so, how? Kindest regards, Michael... WINSNORT.com Management Team Member -- Pick up your FREE Windows or UNIX Snort installation guides mailto:support () winsnort com Website: http://www.winsnort.com Snort: Open Source Network IDS - http://www.snort.org
-----Original Message----- From: snort-users-admin () lists sourceforge net [mailto:snort-users- admin () lists sourceforge net] On Behalf Of Michael Stone Sent: Monday, February 21, 2005 4:05 PM To: snort-users () lists sourceforge net Subject: Re: [Snort-users] BASE performance On Mon, Feb 21, 2005 at 11:55:28AM -0700, Willy, Andrew wrote:We're using BASE / Apache / Snort / MySQL on Win 2k, just recently installed. Many lookups using this front end are very slow, sometimes taking 30-50 seconds to load. Our database is new and not very large. Processor (1ghz) utilization is between %0 and %3. The inital home pages loads quickly, it's only lookups that crawl.On the front page, how many total alerts does it report? For databases processor is largely irrelevant--how much RAM do you have? Have you done any mysql tuning? Mike Stone ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ 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:
- BASE performance Willy, Andrew (Feb 21)
- Re: BASE performance Michael Stone (Feb 21)
- RE: BASE performance Michael Steele (Feb 21)
- <Possible follow-ups>
- RE: BASE performance Willy, Andrew (Feb 22)
- Re: BASE performance Wes Young (Feb 22)
- Re: BASE performance Joel Esler (Feb 22)
- Re: BASE performance Wes Young (Feb 22)
- Re: BASE performance Michael Stone (Feb 21)