How do I check running queries for my Amazon RDS MySQL DB instance?

Last updated: 2020-01-02

I need to see which queries are actively running on an Amazon Relational Database Service (Amazon RDS) DB instance that is running MySQL. How can I do this?

Resolution

To see which queries are actively running for MySQL DB instance on Amazon RDS, follow these steps:

1.    Connect to the DB instance running the MySQL.

2.    Run the following command:

SHOW FULL PROCESSLIST\G

Note: If you don't use the FULL keyword, only the first 100 characters of each statement are shown in the Info field.

3.    Or, run the following query to retrieve the same result set:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST

Note: Your user account must be granted the administration privilege for the MySQL PROCESS server to see all the threads running on an instance of MySQL. Otherwise, SHOW PROCESSLIST shows only the threads associated that are with the MySQL account that you're using. Also note that SHOW FULL PROCESSLIST and INFORMATION_SCHEMA.PROCESSLIST statements can negatively affect performance because they require a mutex.


MySQL documentation for The MySQL Command-Line Client

MySQL documentation for --tee=file_name

MySQL documentation for MySQL Workbench

MySQL documentation for The INFORMATION_SCHEMA PROCESSLIST Table

Did this article help you?

Anything we could improve?


Need more help?