Mysql5.7错误日志时间不对的解决办法
MySQL5.7的错误日志时间和系统时间不一致,看起来费劲,查阅官方文档得知从MySQL 5.7.2 开始,新增了 log_timestamps 参数,它主要是控制 error log、genera log等日志文件的显示时间参数:
官文如下:
This variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to files. It does not affect the time zone of general query log and slow query log messages written to tables (mysql.general_log,mysql.slow_log). Rows retrieved from those tables can be converted from the local system time zone to any desired time zone withCONVERT_TZ()or by setting the sessiontime_zonesystem variable.
Permittedlog_timestampsvalues areUTC(the default) andSYSTEM(local system time zone).
Timestamps are written using ISO 8601 / RFC 3339 format:YYYY-MM-DDThh:mm:ss.uuuuuuplus a tail value ofZsignifying Zulu time (UTC) or±hh:mm(an offset from UTC).
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, notUTC. If you want the previous log message time zone default, setlog_timestamps=SYSTEM.
做了如下修改后,显示正常了:
点击(此处)折叠或打开
(root@localhost) [(none)]> show global variables like 'log_timestamps';+----------------+-------+
| Variable_name | Value |
+----------------+-------+
| log_timestamps | UTC |
+----------------+-------+
1 row in set (0.01 sec)
(root@localhost) [(none)]> set global log_timestamps=SYSTEM;
Query OK, 0 rows affected (0.00 sec)
(root@localhost) [(none)]> SHOW global variables like 'log_timestamps';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| log_timestamps | SYSTEM |
+----------------+--------+
1 row in set (0.01 sec)
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。