Measuring the time MySQL spends in each stage of query execution. MySQL’s SHOW PROFILES and SQLyog’s Query Profiler identify exactly where time is spent in slow queries.