[Snort-users] SNORT file data.MYD too large
edin.dizdarevic at ...7509...
Wed Feb 9 06:41:38 EST 2005
Once the tablespace has become so big, MySQL AFAIK will never shrink it
- even if you delete some data inside. This is common to almost all
databases and a remedy should be considered before creating databases.
The best (only?) method is to delete old alerts and alert you do not
need anymore respectively, dump the rest with mysqldump, delete the big
database files, create a new instance and then reimport the data. For a
more detailed answer look on the Internet or at
corrado.riva at ...13011... schrieb am 09.02.2005 11:52:
> Hello, I've got a problem with snort db table.
> The table data.MYD in /usr/local/mysql/var/snort directory has size
> of 2,3Gb. My disk partition is quite full and I have to resize the
> How can I made this operation ?
> Thanks a lot !!
> Corrado Riva
More information about the Snort-users