首页 > 数据库 > 文库 > 正文

percona server 日志时间错误

2022-07-28 22:41:41
字体:
来源:转载
供稿:网友
       日志时间和系统时间对不上
 
      表现
 
      2016-11-23T02:22:27.520179Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161123 10:22:27
      2016-11-23T02:22:27.792979Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
      2016-11-23T02:22:27.793201Z 0 [Warning] CA certificate ca.pem is self signed.
       2016-11-23T02:22:27.794279Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
 
2016-11-23T10:25:17.358726+08:00 0 [Note] Giving 6 client threads a chance to die gracefully
2016-11-23T10:25:17.358787+08:00 0 [Note] Shutting down slave threads
2016-11-23T10:25:19.358948+08:00 0 [Note] Forcefully disconnecting 6 remaining clients
2016-11-23T10:25:19.358985+08:00 0 [Warning] /home/mysql/mysql/bin/mysqld: Forcing close of thread 20  user: 'xhh_depository_app'
2016-11-23T10:25:19.359019+08:00 0 [Warning] /home/mysql/mysql/bin/mysqld: Forcing close of thread 21  user: 'xhh_depository_app'
2016-11-23T10:25:19.359058+08:00 0 [Warning] /home/mysql/mysql/bin/mysqld: Forcing close of thread 22  user: 'xhh_depository_app'
2016-11-23T10:25:19.359083+08:00 0 [Warning] /home/mysql/mysql/bin/mysqld: Forcing close of thread 24  user: 'xhh_depository_app'
2016-11-23T10:25:19.359096+08:00 0 [Warning] /home/mysql/mysql/bin/mysqld: Forcing close of thread 25  user: 'xhh_depository_app'
2016-11-23T10:25:19.359137+08:00 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 1
2016-11-23T10:25:19.359149+08:00 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
2016-11-23T10:25:19.359207+08:00 0 [Note] Event Scheduler: Stopped
2016-11-23T10:25:19.359221+08:00 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-11-23T10:25:19.359890+08:00 0 [Note] Binlog end
2016-11-23T10:25:19.362051+08:00 0 [Note] Shutting down plugin 'ngram'
2016-11-23T10:25:19.362071+08:00 0 [Note] Shutting down plugin 'partition'
2016-11-23T10:25:19.362091+08:00 0 [Note] Shutting down plugin 'ARCHIVE'
2016-11-23T10:25:19.362094+08:00 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-11-23T10:25:19.362116+08:00 0 [Note] Shutting down plugin 'CSV'
2016-11-23T10:25:19.362120+08:00 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-11-23T10:25:19.362124+08:00 0 [Note] Shutting down plugin 'MyISAM'
 
修改方式
 
mysql> SHOW GLOBAL VARIABLES LIKE 'log_timestamps';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| log_timestamps | UTC   |
+----------------+-------+
1 row in set (0.00 sec)
 
mysql> SET GLOBAL log_timestamps = SYSTEM;
Query OK, 0 rows affected (0.00 sec)

(编辑:错新网)

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表

图片精选