Partition Snort data in MySQL?

Is there a way to partition or segment Snort data stored in MySQL by date? I'd like to keep a revolving four weeks of data on hand, but my Snort configuration presents the following issues:

1. The data.MYD file quickly reaches the file size limitation (4GB) in both Linux and MySQL.
2. Truncating the tables wipes out all the data, and I'd like to keep the most recent data.

I understand the MySQL MERGE command enables partitioning data. Does anyone have a documented process to configure this with Snort's MySQL datafiles?

Thanks,

Michael Received on Fri Dec 20 11:54:30 2002