Finding alerts taking up the most database space

["McCash, John" <John.McCash () andrew com>]

Hi,

               I currently am running snort and acid with mysql, and my
database size is getting up around 6G. The data table, data.MYD alone is
about 3.3G. As you may imagine, my db performance is lousy. Does anyone
have an easy way of determining which alerts are taking up the greatest
amount of db space, so that I can selectively prune those entries?

                              Thanks in advance

                                             John McCash

------------------------------------------------------------------------------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information.  
If you have received it in error, please notify the sender
immediately and delete the original.  Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------------------------------
[mf2]