How do I find out what processes MySQL is running on my SpectroSERVER or Spectrum OneClick system?
NOTE: In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.
To find out what processes MySQL is running, do the following:
1. Log into the SpectroSERVER or OneClick system as the user that owns the Spectrum installation
2. If running on Windows, start a bash shell by running "bash -login"
3. cd to the $SPECROOT/mysql/bin directory
4. Enter the following command to log into MySQL:
./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD>
5. At the "mysql>" prompt, enter the following command to show the process list:
show full processlist;
Output similar to the following should display:
mysql> show full processlist;
+-----+----------+-----------------+-----------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+----------+-----------------+-----------+---------+------+-------+-----------------------+
| 111 | OC_user | localhost:55411 | reporting | Sleep | 8474 | | NULL |
| 112 | OC_admin | localhost:55412 | reporting | Sleep | 8475 | | NULL |
| 113 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+-----+----------+-----------------+-----------+---------+------+-------+-----------------------+
3 rows in set (0.02 sec)
mysql>