修改MySQL日志记录时间为系统时间
来自Linux78|wiki
记录的日志的实际为utc时间,不适合查看,修改为system时间。
mysql> show global variables like 'log_timestamps'; +----------------+-------+ | Variable_name | Value | +----------------+-------+ | log_timestamps | UTC | +----------------+-------+ mysql> set global log_timestamps=SYSTEM; mysql> show global variables like 'log_timestamps'; +----------------+--------+ | Variable_name | Value | +----------------+--------+ | log_timestamps | SYSTEM | +----------------+--------+