Snort mailing list archives
RE: Snort+ACID+MySql DB maint problems
From: "Smith, Aron" <AronSmith () users com>
Date: Mon, 10 Mar 2003 13:32:27 -0500
Well that's not good, I liked ACID too. Is Demarc any better at this task? I'm not a database programmer, but I could probably eventually figure out the right syntax to delete all the relevant records at the same time, but it would take hours. This database is growing pretty fast, to be honest I wouldn't mind a nightly delete function that deletes anything over 30 days old and compacts the database. ___________________________________________ Aron Smith - CCNP, MCSE (aronsmith () users com) Network Services - USERS, Inc. (800) 523-7282 -----Original Message----- From: Paul Schmehl [mailto:pauls () utdallas edu] Sent: Monday, March 10, 2003 12:19 PM To: Smith, Aron Cc: Snort Users List Subject: Re: [Snort-users] Snort+ACID+MySql DB maint problems On Mon, 2003-03-10 at 10:38, Smith, Aron wrote:
I have Snort logging to MySql with no problems, and the ACID web pages work
just fine. The problem is when I go to delete [big] chunks of the database
via ACID the query just sits forever and nothing gets deleted. Any hints?
Yes. Delete smaller chunks. :-) ACID isn't very good about moving large chunks of data. Work with smaller chunks and you'll be fine. -- Paul Schmehl (pauls () utdallas edu) Adjunct Information Security Officer The University of Texas at Dallas http://www.utdallas.edu/~pauls/ AVIEN Founding Member ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ 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:
- Snort+ACID+MySql DB maint problems Smith, Aron (Mar 10)
- Re: Snort+ACID+MySql DB maint problems Paul Schmehl (Mar 10)
- <Possible follow-ups>
- RE: Snort+ACID+MySql DB maint problems Smith, Aron (Mar 10)
- RE: Snort+ACID+MySql DB maint problems Paul Schmehl (Mar 10)