RE: Snort+ACID+MySql DB maint problems

["Smith, Aron" <AronSmith () users com>]

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