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…
