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

Posted by Max Williams on Stack Overflow See other posts from Stack Overflow or by Max Williams
Published on 2010-05-13T09:57:43Z Indexed on 2010/05/13 10:04 UTC
Read the original article Hit count: 358

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about mysql

Related posts about execution-time