How do I check running queries for my Amazon RDS MySQL DB instance?
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?
"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?ResolutionTo 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\GNote: 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.PROCESSLISTNote: 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.Related informationMySQL documentation for The MySQL Command-Line ClientMySQL documentation for --tee=file_nameMySQL documentation for MySQL WorkbenchMySQL documentation for The INFORMATION_SCHEMA PROCESSLIST TableFollow"