mysql持续时间和获取时间 [英] mysql duration and fetch time

问题描述

我正在使用MySQL工作台-运行查询时，持续时间和获取时间之间有什么区别?

I am using MySQL workbench - What is the difference between duration and fetch times when a query is run?

还有没有办法可以在MySQL中启用微秒选项?

Also is there a way I can enable the microsecond option in MySQL?

推荐答案

获取时间-测量传输获取的结果需要多长时间，这与查询执行无关.我不会将其视为sql查询调试/优化选项，因为获取时间取决于网络连接，而网络连接本身与查询优化没有任何关系.如果获取时间成为瓶颈，则很可能存在一些网络问题.

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.

持续时间-是需要执行查询的时间.优化sql查询的性能时，应尝试将其最小化.

Duration time - is the time that query needs to be executed. You should try to minimize it when optimizing performance of sql query.

参考

这篇关于mysql持续时间和获取时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！