文章详情

短信预约-IT技能 免费直播动态提醒

请输入下面的图形验证码

提交验证

短信预约提醒成功

percona server 日志时间不正确

2024-04-02 19:55

关注
日志时间和系统时间对不上

表现

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-23T02:22:27.794306Z 0 [Note] IPv6 is available.
2016-11-23T02:22:27.794313Z 0 [Note]   - '::' resolves to '::';
2016-11-23T02:22:27.794347Z 0 [Note] Server socket created on IP: '::'.
2016-11-23T02:22:27.819248Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2016-11-23T02:22:27.819314Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-11-23T02:22:27.819600Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-11-23T02:22:27.822844Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2016-11-23T02:22:27.852461Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2016-11-23T02:22:27.889447Z 0 [Note] Event Scheduler: Loaded 0 events
2016-11-23T02:22:27.889602Z 1 [Note] Event Scheduler: scheduler thread started with id 1
2016-11-23T02:22:27.889758Z 0 [Note] /home/mysql/mysql/bin/mysqld: ready for connections.
Version: '5.7.15-9-log'  socket: '/home/mysql/my3306/run/mysql.sock'  port: 3306  Source distribution


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'
2016-11-23T10:25:19.362131+08:00 0 [Note] Shutting down plugin 'MEMORY'
2016-11-23T10:25:19.362167+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-11-23T10:25:19.362171+08:00 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2016-11-23T10:25:19.362174+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-11-23T10:25:19.362176+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-11-23T10:25:19.362179+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-11-23T10:25:19.362185+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-11-23T10:25:19.362210+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-11-23T10:25:19.362213+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-11-23T10:25:19.362216+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-11-23T10:25:19.362227+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-11-23T10:25:19.362229+08:00 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-11-23T10:25:19.362232+08:00 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-11-23T10:25:19.362235+08:00 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-11-23T10:25:19.362237+08:00 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-11-23T10:25:19.362240+08:00 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-11-23T10:25:19.362242+08:00 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-11-23T10:25:19.362245+08:00 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-11-23T10:25:19.362247+08:00 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-11-23T10:25:19.362256+08:00 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-11-23T10:25:19.362262+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-11-23T10:25:19.362265+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-11-23T10:25:19.362271+08:00 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-11-23T10:25:19.362273+08:00 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-11-23T10:25:19.362276+08:00 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-11-23T10:25:19.362281+08:00 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'


修改方式

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)



阅读原文内容投诉

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题
  • 2024年上半年信息系统项目管理师第二批次真题及答案解析(完整版)

    难度     813人已做
    查看
  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看
  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看
  • 2024年上半年软考高项第一、二批次真题考点汇总(完整版)

    难度     435人已做
    查看
  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机
位置:首页-资讯-数据库
咦!没有更多了?去看看其它编程学习网 内容吧
首页课程
资料下载
问答资讯