Incorrectly rounded TIME value in I_S.PROCESSLIST
Bug #1056693 reported by
Alexey Kopytov
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Low
|
Unassigned | |||
5.5 |
Triaged
|
Low
|
Unassigned | |||
5.6 |
Triaged
|
Low
|
Unassigned | |||
5.7 |
Triaged
|
Low
|
Unassigned |
Bug Description
The TIME column in I_S.PROCESSLIST may be off by 1 second. Consider the following example:
A query starts at the 0.8 sec timestamp, and takes 0.231 sec. The seconds delta in TIME (that is the difference between the current time in seconds and the start time in seconds) will be 1, but the milliseconds one will be 0.231.
The fix is to calculate the delta using a higher resolution timer and then round it correctly to seconds.
tags: | added: processlist |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1939