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

Question

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

Answer 1

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

mysql> set profiling=1;