Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Show Profiles duration format?

Tags:

php

mysql

I am using the SHOW PROFILES; command along with set profiling=1; to profile my queries, and when I get the profile I get a bunch of durations, and queries and all is well. But I am trying to figure out what format the duration is in. I get a lot of

0.00006300
0.00022700
0.00007000

small numbers, is this milliseconds? Seconds? Nano seconds? Billionth of a second? Some random other value?

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

like image 253
Steven Avatar asked Feb 01 '13 20:02

Steven


2 Answers

You guessed it, it is in seconds.

like image 120
Nox Avatar answered Sep 26 '22 19:09

Nox


It is mentioned in the mysql documentation.. SECONDS

For reference : https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html

like image 30
Pavan Avatar answered Sep 22 '22 19:09

Pavan