db_optimize script terminates

Document ID : KB000111056
Last Modified Date : 14/08/2018
Show Technical Document Details
Issue:
The goal is to optimize the DDMDB on the SpectroSERVERs but the db_optimize.pl script terminates at random intervals.
Cause:
The cause of this is likely an environmental in nature and likely could not be pinpointed.
Resolution:
The workaround to this issue is to utilize the out of the box MySQL Tools to optimize.

1. Navigate a bash shell to $SPECROOT/mysql/bin
2. Type:

Windows: ./mysqlcheck -uroot -proot -o ddmdb
Linux: ./mysqlcheck --defaults-file=../my-spectrum.cnf -uroot -proot -o ddmdb

This will take some time to complete depending on how large the DDMDB database is.
If you are concerned with the overall time it is taking, CA suggests utilizing our chat feature or Communities to engage a Support Engineer.