How to view the currently running MySQL queries

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

1. Log into the server as the 'root' user.
2. Run the following command.

   mysql -e "show processlist;"

View running queries with mysqladmin

1. Log into the server as the 'root' user.
2. Run the following command.

   mysqladmin proc