You will still actually need to optimize the event table to reclaim disk space.
Having SRM configured to purge data after x number of days is a real good
start but the optimize is needed to actually get disk space back.
For instance you can optimize the reporting database with the following:
cd $SPECROOT/mysql/bin
mysqlcheck -uroot -proot -o reporting
As a rule of thumb you will need (2 * sizeOfLargestFile in the mysql/data/reporting directory) of available disk space
in order for the optimize to be successful.
Another thing you might want to consider investigating is why is the reporting/event table
growing at such a large rate ... Perhaps their is a device generating an excessive number
of events that would need further investigation. We provide sample mysql quries which
would be helpful for determining this in the Spectrum_Database_Management_ENU.pdf guide.
Daren