查询执行时间

最新推荐文章于 2024-04-17 15:24:00 发布

一酊甜酒

最新推荐文章于 2024-04-17 15:24:00 发布

阅读量386

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/WH_LPWH/article/details/88806518

版权

Mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

SHOW PROFILE for query 67

SHOW PROFILES

SELECT * from users

SET @query_id = 127;
SELECT
state,
sum( DURATION ) AS Total_r,
round(
100 * sum( DURATION ) / (
SELECT
sum( DURATION )
FROM
information_schema.PROFILING
WHERE
query_id = @query_id
),
2
) AS Pct_r,
count( * ) AS Calls,
Sum( DURATION ) / count( * ) AS “R/Call”
FROM
information_schema.PROFILING
WHERE
query_id = @query_id
GROUP BY
state
ORDER BY
Total_r DESC