InMotion Hosting Support Center

If you are running a MySQL database on your dedicated hosting server, then 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 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

  1. Login to the WHM
  2. Show MySQL processes

    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:

IDThis is the identification number of the running process
UserUser running the process in the database
DBDatabase being used with the process
CommandCommand currently being executed in the process
Time Time taken by the process
stateState of the process
InfoInformation about the process

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 to access it. Note that you will need the appropriate access in SSH in order to use the MySQL command for this report.

  1. Login to SSH.
  2. Type in MYSQL to get into the mysql command line.
  3. Show MySQL processes in command line

    Type show processlist; in order to see current processes on the server.

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!