MySQL查询结果中Duration Time和Fetch Time的含义

浅浅的花香味﹌ 2022-09-04 14:59 206阅读 0赞

## 一 查询 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhbG1fZW5jb2Rl_size_16_color_FFFFFF_t_70][]

## 二 Duration和Fetch的含义 ##

[mysql duration and fetch time - Stack Overflow][]

[MySQL :: Re: Getting the execution time of a query][MySQL _ Re_ Getting the execution time of a query]

> *Fetch time* \- measures how long transferring fetched results take, which has nothing to do with query execution. I would not consider it as sql query debugging/optimization option since fetch time depends on network connection, which itself does not have anything to do with query optimization. If fetch time is bottleneck then more likely there's some networking problem.
> 
> *Note:* fetch time may vary on each query execution.
> 
> *Duration time* \- is the time that query needs to be executed. You should try to minimize it when optimizing performance of sql query.

翻译

> 1、fetch time 是传输获取结果所消耗的时间，与sql语句执行时间无关。由于fetch时间依赖网络连接的快慢，所以不能作为优化sql语句时间参考。如果fetch time过长，需要检查网络原因。
> 
> 2、fetch time 每次执行都可能会变化。
> 
> 3、duration time 是执行sql语句所消耗的时间，对sql语句优化就是减少这个时间。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhbG1fZW5jb2Rl_size_16_color_FFFFFF_t_70]: /images/20220829/10582c1b520746d191e7dff765c61b09.png
[mysql duration and fetch time - Stack Overflow]: https://stackoverflow.com/questions/9425134/mysql-duration-and-fetch-time
[MySQL _ Re_ Getting the execution time of a query]: https://forums.mysql.com/read.php?152,560430,560610#msg-560610