Learning of MySQL Process List

Disclaimer: Accessing the information on this page means you agree to the Sites Privacy Policy & Terms of Use Agreement.


Mysql process is difficult to know as it not easy for beginner, here you will learn how to see process of mysql with mytop tool.

If you are using Ubuntu then here is the command to install mytop :

$ sudo apt-get install mytop

Once you have successfully installed the mytop then you can run below command on terminal. Make sure it will ask password to run it:

$ sudo mytop –prompt

This will show you all db’s process on screen. If you want to see the process list for individual database’s user then below is the command which would help you to identify the process on screen :

$ sudo mytop -u MyDataBase –prompt

Here “MyDataBase” is the Username which created in mysql and you want to see the process for. This command will show you MyDataBase db user’s process on screen.

If you want to see the database’s process list on screen then here is another command which would help you definitely :

$ sudo mytop -d databasename –prompt

Here “databasename” is the name of database for which you want to see the process for. This command will show you database’s process on screen.


This article is contributed by RootLinuxBlog. If you like RootLinuxBlog and would like to contribute, you can submit an article using contact us from. See your article appearing on the RootLinuxBlog main page and help other Techies.
Please write comments if you found any error with the above article would really help us to serve you a better way. Thank you…

Please follow and like us:
MySQL Process List Learning

Leave a Reply

Your email address will not be published. Required fields are marked *

Enjoy this blog? Please spread the word :)

Facebook106
Facebook
LINKEDIN98