MySQL 5.7 Parameter –log_timestamps

http://www.ttlsa.com/mysql/mysql-5-7-kengdieparam-log_timestamps/Website Quote:

This variable is added in MySQL 5.7.2. Before 5.7.2, timestamps in log messages were written using the local system time zone by default, not UTC. If you want the previous log message time zone default, set Log_timestamps=system.

In MySQL 5.7.2 added log_timestamps This parameter, this parameter is mainly control error log, genera log, and so on log display time parameter.
Changing the parameter to default UTC after 5.7.2 causes the log to be recorded in a slower time than the Chinese side, which makes it inconvenient to view the log. Modify to SYSTEM to solve the problem

12345678910111213141516

SHOW GLOBAL VARIABLES like ' log_timestamps '; +----------------+--------+ | variable_name | Value | +----------------+--------+ | log_timestamps | UTC | +----------------+--------+ SET GLOBAL log_timestamps = SYSTEM; Query OK, 0 rows affected (0.00 sec) SHOW GLOBAL VARIABLES like ' log_timestamps '; +----------------+--------+ | variable_name | Value | +----------------+--------+ | log_timestamps | SYSTEM | +----------------+--------+

MySQL 5.7 Parameter –log_timestamps