MySQL Forums
Forum List  »  Performance

lock times in mysqldumpslow
Posted by: Noa Drach
Date: June 24, 2013 07:36AM

I run mysqldumpslow and the values that I for the lock don't make sense to me.
please help me understand what is represented here:

Count: 33858 Time=0.00s (55s) Lock=4358613993.43s (147573952589678s)

I think that it's clear that the lock of one query didn't took 4358613993.43 seconds, so how much did it take?
maybe it's some bug in the mysqldump slow that is a result of the fact that the query run 33858 time?

if I look at the query in the slow queries log I see values like
# Query_time: 0.004610 Lock_time: 0.000171
what time unit is seen in the slow queries log

[I run on mysql 5.6.10 on Linux]

Options: ReplyQuote


Subject
Views
Written By
Posted
lock times in mysqldumpslow
1655
June 24, 2013 07:36AM
870
June 25, 2013 10:18PM
682
July 02, 2013 08:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.