Taking up to 30 minutes to log into mysql on the Spectrum Report Manager system
Article ID: 127075
Updated On:
Products
Issue/Introduction
When logging into mysql on the Spectrum Report Manager (SRM) system, it is taking up to 30 minutes for the login to complete.
Environment
Release: Any
Component: SPCRPT
Cause
When you type "use database" it will load the metadata, columns, tables, etc. With a large database, this could take some time to accomplish.
Resolution
NOTE: In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.
To speed up the login process, use the "-A" option
- Log into the SRM system as the user that owns the Spectrum installation
- If on Windows, start a bash shell by running "bash -login"
- cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql and use the reporting database:
./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting -A
Additional Information
It is also recommended to periodically clean up the database to keep it healthy and remove purged data. Please reference "HOW TO Optimize SRM mysql table to return free disk space when "purge" is not clearing disk" for more information.
Feedback
