MySQL 5.7 參數 – log_timestamps

標籤：

http://www.ttlsa.com/mysql/mysql-5-7-kengdieparam-log_timestamps/官網原話：

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.

在MySQL 5.7.2 新增了 log_timestamps 這個參數，該參數主要是控制 error log、genera log，等等記錄日誌的顯示時間參數。
在 5.7.2 之後改參數為預設 UTC 這樣會導致日誌中記錄的時間比中國這邊的慢，導致查看日誌不方便。修改為 SYSTEM 就能解決問題

 

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 參數 – log_timestamps