开发者

mysqldumpslow query time difference

开发者 https://www.devze.com 2023-01-24 16:14 出处:网络
I am a new user to mysqldumpslow and I am trying to understand the following: a) What is the difference between Query time and average query time ?

I am a new user to mysqldumpslow and I am trying to understand the following:

a) What is the difference between Query time and average query time ?

b) For a query like this :

Count: 12 Time=363.73s (4364s) Lock=0.00s (0s) Rows=0.0 (0), ekb[ekb]@localhost delete from sys_temp_random

What does this time va开发者_JAVA百科lue represent - (4364s) ?


That number represents the total time spent on the query.


What does this time value represent - (4364s)?

Its the total count (no of times this query run) multiplied by the average running time then the result get floored => floor (12 * 363.73) = 4364

0

精彩评论

暂无评论...
验证码 换一张
取 消