Query MySQL For Top CPU Intensive Queries?
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
Subject
Views
Written By
Posted
Query MySQL For Top CPU Intensive Queries?
3168
July 22, 2021 10:34AM
1476
July 22, 2021 12:20PM
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.