修改MySQL日志记录时间为系统时间

  • A+
所属分类：Database

最近编译安装MySQL5.7.x后，记录的日志的实际为utc时间，不适合查看，修改为system时间。

0
1
2
3
2017-03-24T04:59:45.826506Z 73035 [Note] Aborted connection 73035 to db: 'a' user: 'root' host: '1.1.1.1' (Got an error reading communication packets)
2017-03-24T05:09:37.163762Z 72352 [Note] Aborted connection 72352 to db: 'a' user: 'root' host: '1.1.1.1' (Got an error reading communication packets)
2017-03-24T05:20:40.719462Z 66896 [Note] Aborted connection 66896 to db: 'a' user: 'root' host: '1.1.1.1' (Got an error reading communication packets)
2017-03-24T05:53:02.994317Z 76079 [Note] Aborted connection 76079 to db: 'a' user: 'root' host: '1.1.1.1' (Got an error reading communication packets)

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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.00 sec)