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

To better understand the performance profile of an instance of MySQL running on Amazon RDS, I need to know what queries 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 a DB instance running the MySQL database engine.
  2. Run the following command:
         SHOW FULL PROCESSLIST\G

Note
A user account must be granted the MySQL PROCESS Server Administration privilege in order to see all threads running on an instance of MySQL. Otherwise, SHOW PROCESSLIST displays only the threads associated with the MySQL account that you are using. If you do not use the FULL keyword, only the first 100 characters of each statement are shown in the Info field.

Amazon RDS, MySQL, view queries, process privilege, performance, troubleshooting


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.