I need to view server activity 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 the state of the InnoDB storage engine, what queries are running, or if there are any deadlocks on the instance at any given time.

To view server activity for an instance of MySQL on Amazon RDS, follow these steps:

  1. Enable the general and slow query logs for your MySQL instance by completing appropriate steps described in How do I enable and monitor logs for my Amazon RDS MySQL instance?
  2. Connect to the DB instance running the MySQL database engine.
  3. Run the following commands.
         SHOW FULL PROCESSLIST\G
         SHOW ENGINE INNODB STATUS\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. A user account must also be granted the MySQL PROCESS Server Administration privilege to use SHOW ENGINE and view information about the state of the InnoDB storage engine.

Amazon RDS, MySQL, server activity, 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.