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

To understand the performance profile of an instance of MySQL running on Amazon RDS, view the queries that are running on the instance at any given time.

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

1.    Connect to the DB instance running the MySQL database engine.

2.    Run the following command:

SHOW FULL PROCESSLIST\\G

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 in order to see all the threads running on an instance of MySQL. Otherwise, SHOW PROCESSLIST shows only the threads associated with the MySQL account that you're using. If you don't use the FULL keyword, only the first 100 characters of each statement appear in the Info field.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-07-07

Updated: 2018-07-27