mysql 部分参数说明

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

 

posted @ 2017-11-29 19:06  醉梦一生  阅读(160)  评论(0编辑  收藏  举报