RE: ACID Database Cleanup (data.MYD)

[Michael Aylor <maylor () swbanktx com>]

Trying running an "optimize" on the tables in question.  Check www.mysql.com
documentation for exact syntax.

-----Original Message-----
From: krista l merrill [mailto:kmerr001 () cs fiu edu]
Sent: Monday, April 29, 2002 12:21 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] ACID Database Cleanup (data.MYD)



I am using ACID to delete the alerts from my MySQL database, but the
data.MYD table doesn't seem to get smaller.  What should I do to prevent
this?

A previous post to this question said:

From: skc () lanl gov
Date: 2001-10-16

"If you use ACID to do the delete, the payload entry in the data table
should be removed.  If you are assuming the payloads are not being removed
because the size of the data.MYD is not getting smaller ... that is not a
good indicator.  The data.MYD will forever be 4.2 gig from now on ... that
is the way mysql works.  If ACID said it deleted the alerts, you can be
pretty sure the payload entry was removed from data.MYD."

What causes data.MYD to be so large, and how can decrease the size of the
table?

Thank you,

Kris


_______________________________________________
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


CONFIDENTIALITY NOTICE:

************************************************************************

The information contained in this ELECTRONIC MAIL transmission
is confidential.  It may also be privileged work product or proprietary
information. This information is intended for the exclusive use of the
addressee(s).  If you are not the intended recipient, you are hereby
notified that any use, disclosure, dissemination, distribution [other
than to the addressee(s)], copying or taking of any action because
of this information is strictly prohibited.

************************************************************************