奇怪的主从复制问题
##
奇怪的主从复制问题
今天在修正一客户的事务隔离级别时发现了一个奇怪的问题，主从复制中从库的线程Time值为负数。
1、现象
processlist的Time值有三个负数和一个正数，检查信息如下：
mysql> show full processlist;
+---------+-------------+-----------------+------+---------+----------+----------------------------------------------------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+-------------+-----------------+------+---------+----------+----------------------------------------------------------+-----------------------+
| 5 | system user | connecting host | NULL | Connect | 18183371 | Waiting for source to send event | NULL |
| 6 | system user | | NULL | Query | 0 | Replica has read all relay log; waiting for more updates | NULL |
| 7 | system user | | NULL | Query | -494 | Waiting for an event from Coordinator | NULL |
| 8 | system user | | NULL | Query | -490 | Waiting for an event from Coordinator | NULL |
| 9 | system user | | NULL | Query | -440 | Waiting for an event from Coordinator | NULL |
| 10 | system user | | NULL | Query | 6184 | Waiting for an event from Coordinator | NULL |
| 1265587 | root | localhost | NULL | Query | 0 | init | show full processlist |
+---------+-------------+-----------------+------+---------+----------+----------------------------------------------------------+-----------------------+
7 rows in set (0.00 sec)
