mysql query execution time - can i get this in mil

2020-07-06 02:15发布

Possible Duplicate:
how to get load time in milliseconds or microseconds in mysql

I'm comparing a few different approaches to getting some data in mysql, directly at the console, using the SQL_NO_CACHE option to make sure mysql keeps running the full query every time. Mysql gives me the execution time back in seconds, to two decimal places. I'd really like to get the result back in milliseconds (ideally to one or two decimal places), to get a better idea of improvements (or lack of). Is there an option i can set in mysql to achieve this?

thanks, max

1条回答
甜甜的少女心
2楼-- · 2020-07-06 02:57

The answer is to enable the mysql profiler and then check it after you run your queries.

mysql> set profiling=1;
查看更多
登录 后发表回答