| Bug #58189 | SHOW FULL PROCESSLIST shows query duration time of "-1" for it's own process | ||
|---|---|---|---|
| Submitted: | 15 Nov 2010 2:47 | Modified: | 2 Jan 2016 5:07 |
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.5.7rc | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[15 Nov 2010 2:47]
Roel Van de Paar
[15 Nov 2010 2:49]
Roel Van de Paar
Full output at time of bug
Attachment: full output bug 58189.txt (text/plain), 3.78 KiB.
[15 Nov 2010 10:08]
Peter Laursen
not here (win7/64 bit server)
SELECT VERSION(); -- 5.5.7-rc
SHOW FULL PROCESSLIST
/*
Id User Host db Command Time State Info
------ ------ --------------- ------ ------- ------ ------ ---------------------
1 root localhost:54222 (NULL) Query 0 (NULL) show full processlist
2 root localhost:54223 (NULL) Sleep 8 (NULL)
*/
... but there is no 'heavy load' here!
[2 Jan 2016 5:07]
MySQL Verification Team
changing this from verified to can't repeat. there is no testcase, and haven't seen this myself (without setting timestamp) and/or changing clocks.
