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%
You guessed it, it is in seconds.
It is mentioned in the mysql documentation.. SECONDS
For reference : https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With