perconaserver日志时间不正确
日志时间和系统时间对不上
表现
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)
网页题目：perconaserver日志时间不正确
链接分享：http://scyanting.com/article/ipiphc.html
表现
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)
网页题目：perconaserver日志时间不正确
链接分享：http://scyanting.com/article/ipiphc.html
