Shulou(Shulou.com)06/01 Report--

Log time and system time do not match

Performance

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-9murlog' 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'

Modification mode

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.