开发者

MySQL - how to read output of "profile query"

开发者 https://www.devze.com 2023-02-17 16:51 出处:网络
In the below output, what does the 22.071324 duration refer to - Sending data or executing? The natural way to read the output is 22 sec for Sending data, and this post from MySQL refers to the times

In the below output, what does the 22.071324 duration refer to - Sending data or executing?

The natural way to read the output is 22 sec for Sending data, and this post from MySQL refers to the times this way. Also, the documentation does not caution that the table needs to be interpreted in a special way.

So why 开发者_StackOverflow中文版am I asking this question? I came across this post, which refers to this post, where someone claims they read the source code and the 22 sec time should be interpreted as corresponding to executing.

Can anyone definitively say one way or another?

mysql> show profile for query 4;
+----------------------+-----------+
| Status               | Duration  |
+----------------------+-----------+
| starting             |  0.000052 |
| checking permissions |  0.000007 |
| Opening tables       |  0.000027 |
| System lock          |  0.000008 |
| init                 |  0.000019 |
| optimizing           |  0.000008 |
| statistics           |  0.034766 |
| preparing            |  0.000011 |
| executing            |  0.000002 |
| Sending data         | 22.071324 |
| end                  |  0.000012 |
| query end            |  0.000005 |
| closing tables       |  0.000020 |
| freeing items        |  0.000170 |
| logging slow query   |  0.000001 |
| logging slow query   |  0.000003 |
| cleaning up          |  0.000004 |
+----------------------+-----------+


I can definitely confirm that 22 seconds should be interpreted as "executing" rather than sending the data. Digging trough the source code of MySQL and talking to several people confirmed that.

0

精彩评论

暂无评论...
验证码 换一张
取 消