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

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

This question and answers originated from www.stackoverflow.com
Question by (5/13/2010 9:57:43 AM)

Answer

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

mysql> set profiling=1;
Answer by
Find More Answers
Related Topics  mysql  execution-time
Related Questions