MySQL(或pxc)5.7的错误日志显示的时间和系统时间不一致,查阅官方文档可知:从MySQL5.7.2开始,新增了log_timestamps 参数,它主要是控制error log、genera log等日志文件的显示时间。比如:xxxx.err
如果 log_timestamps 的值为 UTC 则会比系统时间慢8个小时,如果要确保mysql(或pxc)5.7的错误日志显示的时间和系统时间一致,log_timestamps 的值应该设置为 SYSTEM
查看:
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)
再次查看:
mysql> show global variables like 'log_timestamps';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| log_timestamps | SYSTEM |
+----------------+--------+
1 row in set (0.01 sec)