Forum Topic

Thanks for your participation and contribution.


Back to MySQL Queries

MySQL Performance Metrics

Post a reply
2831 views
i90runner
i90runner

use performance_schema ;

SELECT
*
FROM performance_schema.events_statements_summary_by_digest
where SCHEMA_NAME like 'Portal'
and digest_text like 'CALL%'
ORDER BY Last_Seen DESC 
LIMIT 10;

SELECT
  digest_text,
  count_star / update_total * 100 as percentage_of_all
FROM events_statements_summary_by_digest,
( SELECT sum(count_star) update_total
  FROM events_statements_summary_by_digest
  WHERE digest_text LIKE 'CALL%'
) update_totals
WHERE digest_text LIKE 'CALL%'
ORDER BY percentage_of_all DESC
LIMIT 10

Last updated

i90runner

1-2 of 2

Reply to this discussion

You cannot edit posts or make replies: You should be logged in before you can post.