Is optimizing the Archive Managers mysql database recommended?
Article ID: 400483
Updated On:
Products
Issue/Introduction
We have had a cron job running on our SpectrorSERVERS for the $SPECROOT/SS/DDM/scripts/db_optimize.pl and would like to know if it is still required or recommended as the mysql db version has been upgraded over time.
Resolution
Yes optimizing the mysql database on the SpectroSERVER using the db_optimize.pl script in the $SPECROOT/SS/DDM/scripts directory is recommended. You can utilize a cron job or run it from command line. It should be run on each SS every few months or so.
You can run the db_optimize.pl script using the following steps to put it in the background.
Navigate as the spectrum install owner to the $SPECROOT/SS/DDM/scripts directory and run:
nohup yes "Y" | perl ./db_optimize.pl > optimize_output.log 2>&1 &
This script does stop and restart the ArchMgr process in between optimizing all 14 tables in the ddm database. It waits 10 minutes in between each table therefore it takes a minimum of 140 minutes to run.
Additional Information
Additional information can be found in our documentation:
Feedback
