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)
