mysql 判断日志时间早_MySQL5.7慢查询日志时间与系统时间差8小时原因详解

UTC大家都知道是世界统一时间，而我现在的系统时间是东八区，比UTC早了8个小时，这就对上了。查看官方文档看一下官网的解释。

log_timestamps

Property Value

Command-Line Format --log-timestamps=#

Introduced 5.7.2

System Variable log_timestamps

Scope Global

Dynamic Yes

Type Enumeration

Default Value UTC

Valid Values

UTC

SYSTEM

This variable controls the time zone of timestamps in messages written to the error log, and in general query log and slow query log messages written to files. It does not affect the time zone of general query log and slow query log messages written to tables (mysql.general_log, mysql.slow_log). Rows retrieved from those tables can be converted from the local system time zone to any desired time zone with CONVERT_TZ() or by setting the session time_zone system variable.

Permitted log_timestamps values are UTC (the default) and SYSTEM (local system time zone).

Timestamps are written using ISO 8601 / RFC 3339 format: YYYY-MM-DDThh:mm:ss.uuuuuu plus a tail value of Z signifying Zulu time (UTC) or ±hh:mm (an offset from UTC).

修改参数就可以解决问题。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 |

+----------------+--------+

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持IIS7站长之家。

转载：非常欢迎各位朋友分享到个人站长或者朋友圈，但转载请说明文章出处“黎青松SEO博客”。