Hi Chris,
For SRM use oneclick home page -> Administration -> Report manager -> Preferences
As per the Data Retention Policy if you select purge then it will remove the records beyond the Data Retention period and it should optimize to free up the space
in case if you want to optimize manually then you need to follow below steps
bash -l
cd mysql/bin
./mysql -uroot -proot reporting;
optimize table {table-name};
NOTE: this needs 2.5 times free space in that drive. Example if the table is 1 GB then it need 2.5GB of free space.
Also you cannot run optimize on below tables as the engine is innodb
alarmactivity
alarminfo
devicemodel
devicemodel_uda
model
model_state
modeloutage
ncm_config
ncm_config_text
spmbasictestresults
spmhttpfulltestresults
spmjittertestresults
Hope this helps.
Sunny