I am archiving Spectrum Report Manager data but the reporting directory is not reducing in size.

Document ID : KB000003948
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Using Archive or Purge options for SRM retention policy does not appear to be reclaiming disk space. How do I get that disk space back? 

Cause:

This is because of how MySQL handles disk space and how it allocates it. The issue is that once MySQL has allocated disk space it will remain that size until the table is optimized.

Resolution:

To optimized the tables and gain the disk space

  1. Navigate to the $SPECROOT/mysql/bin directory

    Type the following: ./mysqlcheck -uroot -proot -o reporting

    Let this run to completion.

 

If you see any errors like this:"The storage engine for the table doesn't support optimize", it can be safely ignored. When complete, verify disk space has been regained.