How do I find out what processes MySQL is running on my SpectroSERVER or Spectrum OneClick system?

Products

• Spectrum
• Network Observability

Issue/Introduction

How do I find out what processes MySQL is running on my SpectroSERVER or Spectrum OneClick system?

Environment

Release: Any
Component:

Resolution

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>