ntpdate会导致mysql slow query log出现很大的query time

mysql官方有对此事的论述:http://bugs.mysql.com/bug.php?id=9579

在我得系统里我发现了这种事情:
mysql的日志:
# Time: 080308 18:07:01
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
# Query_time: 4294967294  Lock_time: 0  Rows_sent: 1  Rows_examined: 0


系统的ntpdate的日志:
 8 Mar 18:00:02 ntpdate[14503]: adjust time server 172.23.16.24 offset 0.009211 sec
TIMESERVER=172.23.16.24
HEADMARK        172.16.216.32   [2008-03-08 18:07][log]ntpdate query offset: 2
HEADMARK        172.16.216.32   [2008-03-08 18:07][log]ntpdate query offset: 2
HEADMARK        172.16.216.32   [2008-03-08 18:07][log]offset is 2, will run ntpdate now...
HEADMARK        172.16.216.32   [2008-03-08 18:07][log]offset is 2, will run ntpdate now...
Looking for host 172.23.16.24 and service ntp
 8 Mar 18:07:01 ntpdate[14913]: step time server 172.23.16.24 offset -2.547730 sec
TIMESERVER=172.23.16.24
HEADMARK        172.16.216.32   [2008-03-08 18:14][log]ntpdate query offset: 0
HEADMARK        172.16.216.32   [2008-03-08 18:14][log]ntpdate query offset: 0
HEADMARK        172.16.216.32   [2008-03-08 18:14][log]offset is 0, will run ntpdate now...
HEADMARK        172.16.216.32   [2008-03-08 18:14][log]offset is 0, will run ntpdate now...
Looking for host 172.23.16.24 and service ntp
 8 Mar 18:14:02 ntpdate[15184]: adjust time server 172.23.16.24 offset 0.014846 sec
TIMESERVER=172.23.16.24
HEADMARK        172.16.216.32   [2008-03-08 18:21][log]ntpdate query offset: 0
HEADMARK        172.16.216.32   [2008-03-08 18:21][log]ntpdate query offset: 0
HEADMARK        172.16.216.32   [2008-03-08 18:21][log]offset is 0, will run ntpdate now...
HEADMARK        172.16.216.32   [2008-03-08 18:21][log]offset is 0, will run ntpdate now...
Looking for host 172.23.16.24 and service ntp
 8 Mar 18:21:01 ntpdate[15516]: adjust time server 172.23.16.24 offset 0.010321 sec

请使用浏览器的分享功能分享到微信等