log_timestamps [5.7]
This variable was 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
.
log_timestamps 这个参数主要是控制 error log、slow_log、genera log,等等记录日志的显示时间参数,5.7.2之前的版本都是默认的 本地系统时间【local system time zone】,从5.7.2版本开始,默认为utc 时间,当然可以更改为本地系统时间,建意最好更改配置文件 [mysqld] log_timestamps = system