Sometimes we can see strange times in SHOW PROCESSLIST, i.e.:
mysql> select * from information_schema.processlist where command!='Sleep';
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
| ID | USER | HOST | DB |
COMMAND | TIME |
STATE |
INFO |
TIME_MS |
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
| 19236439 | root | localhost | NULL |
Query | 0 |
executing | select *
from information_schema.processlist where command!='Sleep' |
0.478 |
| 19221966 | cardbee | 192.168.100.41:38886 | cardbee_production |
Query | 18446744073709 |
NULL |
NULL |
18446744073709550.000 |
| 18073082 | slave | 192.168.100.22:6389 | NULL |
Binlog Dump | 210340 | Has sent all binlog to slave; waiting for
binlog to be updated |
NULL
| 210340986.341 |
| 18008531 | slave | 192.168.100.23:50055 | NULL |
Binlog Dump | 225897 | Has sent all binlog to slave; waiting for
binlog to be updated |
NULL
| 225897897.500 |
| 17993363 | system user | | NULL |
Connect | 0 | Has read all relay log; waiting for the slave
I/O thread to upda |
NULL
| 11.957 |
| 17993362 | system user | | NULL |
Connect | 229693 | Waiting for master to send
event |
NULL
| 229693423.131 |
+----------+-------------+----------------------+--------------------+-------------+----------------+------------------------------------------------------------------+---------------------------------------------------------------------+-----------------------+
6 rows in set (0.00 sec)
This bug similar to bug 600360
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1153