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