Geek Answers Handbook

MySQL Show Display Duration Display Format?

I use the SHOW PROFILES; together with set profiling=1; to profile my requests, and when I get the profile, I get a bunch of durations, and the requests are all right. But I'm trying to figure out what format the duration is in. I get a lot

 0.00006300 0.00022700 0.00007000

Small numbers, is it milliseconds? Seconds? Nano seconds? Billion fractions of a second? Any random other meaning?

I could not find any documentation about what it is. It looks like seconds, but I would like to know 100%

+4
source share
3 answers

You guessed what it is in seconds.

+3
source

This is mentioned in the mysql documentation. SECONDS

For reference: http://dev.mysql.com/doc/refman/5.5/en/profiling-table.html

+2
source

Run the command in seconds. And your result is microseconds: 63, 227, 70

0
source

More articles:


All Articles