There will be times that restarting the MySQL server is not possible and debugging needs to be done.

Release: Any

NOTE:  In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

To enable debug without restarting mysql:

1. Log into the System as the user that owns the Spectrum installation

2. ON Windows, start a bah shell by running "bash -login"

3. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD>

4. Enter the following command at the mysql prompt to enable the debugging:

set global general_log = 'on';

Note: On a Spectrum Report Manager host that can easily generate hundreds of queries per minute, the log file will grow in size quickly.

The log file generated is created in the $SPECROOT/mysql/data directory. It is called <hostname>.log where hostname is the actual hostname of the system you are on.

5. To disable the debug, enter the following command at the mysql prompt:

set global general_log = 'off';