MySQL Forums
Forum List  »  Performance

Query MySQL For Top CPU Intensive Queries?
Posted by: Carlos Mennens
Date: July 22, 2021 10:34AM

I'm new to MySQL and since we're using Aurora in RDS, a lot of the basics are locked out from an admin perspective since I don't have full access to the server / database.
I have enhanced monitoring enabled to see the graphs / charts of performance but I'd like to query the system tables directly to get a table based output I can report on showing what my top (x) queries are based on CPU avg.

Is it possible to get this info from the command line in a table format or some other way outside of the AWS RDS console graphs? I'd like to put this data in Excel for reporting so I assumed it's better to figure out how to query performance directly from the system tables -vs- relying on the console in rds.

Appreciate any help or suggestions on how I can query this info on my server.


Options: ReplyQuote

Written By
Query MySQL For Top CPU Intensive Queries?
July 22, 2021 10:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.