-
臨時設置
mysql> show variables like '%log_timestamps%';+----------------+-------+| Variable_name | Value |+----------------+-------+| log_timestamps | UTC |+----------------+-------+1 row in set (0.00 sec)系統是 CST ， nysql 是 UTC當UTC時間為0點時，中國CST時間為8點，因為零時區和中國北京時區相差8個時區所以， /var/log/mysqld.log 鐘的時間要 + 8 小時mysql> SET GLOBAL log_timestamps=SYSTEM; mysql> SET GLOBAL log_timestamps=SYSTEM; Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%log_timestamps%';+----------------+--------+| Variable_name | Value |+----------------+--------+| log_timestamps | SYSTEM |+----------------+--------+1 row in set (0.01 sec)
這樣設置，退出回話，設置就消失了
-
永久設置需要
修改 my.inf,加上# vim /etc/my.cnf...log_timestamps=SYSTEM重啟服務
systemctl restart mysqld -
制造一個 mysql 事件驗證一下
# systemctl stop mysqld# date2023年 08月 18日 星期五 08:03:59 CST# tail /var/log/mysqld.log ...2023-08-18T08:03:56.992722+08:00 0 [Note] Shutting down plugin 'mysql_native_password'2023-08-18T08:03:56.993110+08:00 0 [Note] Shutting down plugin 'binlog'2023-08-18T08:03:56.993737+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete啟動服務
systemctl start mysqld
