If you are running a MySQL database on your Dedicated Hosting server, you may want to see its status in terms of the processes that it is currently running. This will give you an idea of the load on the database server which is important if you have a large database or several databases being served on your server. It is also useful to help pinpoint problems with queries running on the server.
You will need to have root access to the server in order to use either of these reports.
Using WHM to Show MySQL Processes
- Login to the WHM
Click on Show MySQL Processes in the menu at left.
You will see table showing the existing processes for your dedicated hosting server. These items are detailed below:
|ID||This is the identification number of the running process|
|User||User running the process in the database|
|DB||Database being used with the process|
|Command||Command currently being executed in the process|
|Time||Time taken by the process|
|state||State of the process|
|Info||Information about the process|
You can also kill MySQL processes.
Show MySQL Processes in SSH
If you are familiar with using MySQL in command line, you can also get the report on running processes there. The following instructions show how to access it. Note that you will need the appropriate access in SSH in order to use the MySQL command for this report.
- Login to SSH.
- Type in MYSQL to get into the mysql command line.
Type show processlist; in order to see current processes on the server.
Do you find that you just don’t have the time to manage your servers yourself? Our Managed VPS Hosting is the perfect solution.