My question is related to extract the performance matrix of the queries ran is past on MYSQL (Innodb ) version 8. We need to find out the query plan, resources used by the queries ran in past on Mysql.
Just similar to the Teradata, using DBQL/PDCR, all the stats can be captured of the queries ran in past.
If you are running MySQL Enterprise Monitor you will have all that information at hand. If not, some of it may be able to obtained from the information_schema.