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
在我得系统里我发现了这种事情:
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/82392/viewspace-201891/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/82392/viewspace-201891/