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

Document ID : KB000057626
Last Modified Date : 14/02/2018
Show Technical Document Details

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

 

ANSWER: To find out what pprocesses 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 -proot

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>