Shulou(Shulou.com)05/31 Report--

This article shows you how to analyze the performance of MySQL SQL sentences, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Performance Analysis of MySQL SQL statement

Set profiling = 1

Select * from g_staff

Show profiles

Www.2cto.com

SHOW profile CPU,BLOCK IO FOR query 88

Select * from NFORMATION_SCHEMA.PROFILING

Convert the result of the MySQL's SHOW PROFILES command to a format suitable for reading

SET @ query_id: = 5

SELECT

STATE

SUM (DURATION) AS Total_R

ROUND (

100 * SUM (DURATION) /

SELECT

SUM (DURATION)

FROM

INFORMATION_SCHEMA.PROFILING

WHERE www.2cto.com

QUERY_ID = @ query_id

),

two

) 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

The above is how to analyze the performance of MySQL SQL statements. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.