Report Manager mysql command - use reporting - takes over 30 min.


Article ID: 127075


Updated On:


CA Spectrum


Customer noticed that when logging into MySql and running the command:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot

... was able to login to MySql, but then to login to the Reporting DB with:
use reporting;

... that it will take over 30 min. to get back the prompt.

What is the reason and solution to get this faster.


Component: SPCRPT


When you type "use database" it will load the metadata, columns, tables, etc.

Often seen when there are a lot of bucket tables as well.

Customer need to:
1. Clean up the database (don't store as much)
2. Optimize the database
3. For now they can send "-A" to the mysql connect command to prevent loading of the metadata.

Customer used the "-A" option to login to mysql reporting database.

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A

Now, the login to the reporting DB is quicker (seconds).