mysql query execution time - can i get this in milliseconds? [duplicate]

This question already has answers here: Closed 10 years ago.

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?

t开发者_如何学编程hanks, max

---

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

mysql> set profiling=1;