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.

Thanks

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.