Maintenance of the SRM database

[Anon Anon]

Hey,

I am wondering if anybody here has some hints for the maintenance of the SRM database (reporting). There are two scripts to maintain the DDMdb, but nothing for the SRMdb. Anybody here doing optimize tables periodically on the SRMdb or has other hints for me?

Regards,

  Christoph

[Sanyasirao Chillarige]

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

[Anon Anon]

Hi Sunny,

thanks for the hints. I have to optimze my events table I think and it is good the see, that the normal mysql command are supported.

Regards,

  Chris

[vrbto01]

How do you mean:

Also you cannot run optimize on below tables as the engine is innodb

I see opposite here.windows - Howto: Clean a mysql InnoDB storage engine? - Stack Overflow