Introduction
When mysqld is causing significant load, you will want to see what queries are currently running.
Procedure
The running queries can be seen with the mysql and mysqladmin commands. Both commands provide the same output.
View running queries with mysql
- Log into the server as the 'root' user.
- Run the following command.
mysql -e "show processlist;"
View running queries with mysqladmin
- Log into the server as the 'root' user.
- Run the following command.
mysqladmin proc
Comments
0 comments
Article is closed for comments.