MySQL Spotting Performance Problems

[@anchalajay9715]

you have not added the query in the description.

[@shamilsaleem9444]

i think he is referring to the udemy course

[@ayazahamed8254]

Very well explained. Useful content.

[@fahdbahoo1]

SELECT (100 * SUM_TIMER_WAIT / sum(SUM_TIMER_WAIT)
OVER()) percent,
SUM_TIMER_WAIT AS total,
COUNT_STAR AS calls,
AVG_TIMER_WAIT AS mean,
substring(DIGEST_TEXT , 1, 75),
DIGEST_TEXT
FROM performance_schema.events_statements_summary_by_digest
ORDER BY SUM_TIMER_WAIT DESC
LIMIT 10 ;

[@stefanjagger]

Thanks

[@cjbarroso]

thank you very much, you are an excellent teacher

[@gregoryplaza]

this is a very useful material, I really appreciate your time and dedication very well explanation of some performance topics, awesome job sr.

[@satishshinde5300]

Can you share query??

[@givemorenenohwe2973]

thank you