how to get most CPU usage queries for the day
Posted by: mysql dba
Date: July 23, 2021 11:27AM

I'm trying to prepare a report and part of this i need to generate a report of top sql queries which are consuming most of the CPU by load.
mysql workbench performance reports has an option (high cost sql statements > statement analysis) but its reporting since the db started. how do i limit the range for a day or week..etc..

mysql : 8.0.23


thanks

Options: ReplyQuote


Subject
Written By
Posted
how to get most CPU usage queries for the day
July 23, 2021 11:27AM


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.