ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ntpdate会导致mysql slow query log出现很大的query time

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

原创 Linux操作系统 作者:bulletming 时间:2019-03-30 21:24:05 0 删除 编辑
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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/82392/viewspace-201891/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2004-05-31

  • 博文量
    121
  • 访问量
    106598