MySql:获得比百分之一秒更精确的时间测量
当我在 MySql 中运行 SQL 或使用 BENCHMARK
命令时,我得到如下结果:
2 rows in set (0.00 sec)
0.00 秒对于某些查询来说意义不大,有时需要更高的精度来弄清楚如何long 查询需要更小的时间单位。在 MySql 中如何做到这一点?
When I run a SQL in MySql or I use the BENCHMARK
command, I get a result like the following:
2 rows in set (0.00 sec)
0.00 sec isn't very meaningful for some queries, and sometimes more precision is needed to figure out how long a query took in an even smaller unit of time. How do you do this in MySql?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
查看
Profilers
,例如 http://www.jetprofiler.com/和其他...另外,这个问题有一些建议: Is there a Profiler equal为了MySql?
Look into
Profilers
, such as http://www.jetprofiler.com/ and others...Also, this question has some suggestions: Is there a Profiler equivalent for MySql?