测量实际的MySQL查询时间 [英] Measuring actual MySQL query time

问题描述

如何测量查询的执行时间，而不测量等待锁定释放等的时间?我唯一的想法是连续测量相同的查询并记录最快的时间.

解决方案

使用

启动事件探查器

SET profiling = 1;

然后执行查询.

使用

SHOW PROFILES;

您会看到分析器具有统计信息的查询列表.最后，您选择要使用的查询

SHOW PROFILE FOR QUERY 1;

或查询中包含的任何数字.

您将获得一个列表，其中列出了查询期间确切花费了多少时间.

手册中的更多信息.

How can I measure the execution time of a query without measuring the time it spends waiting for a lock release etc? My only idea was to continuously measure same query and record the fastest time.

解决方案

Start the profiler with

SET profiling = 1;

Then execute your Query.

With

SHOW PROFILES;

you see a list of queries the profiler has statistics for. And finally you choose which query to examine with

SHOW PROFILE FOR QUERY 1;

or whatever number your query has.

What you get is a list where exactly how much time was spent during the query.

More info in the manual.

这篇关于测量实际的MySQL查询时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！