MySQL changed the timestamp format in the log files in MySQL 5.7.
Since then, I have a few times seen questions about the new
format, and how to change the time zone that is used. Latest in a
comment to my blog about log_slow_extra
in
8.0.14, where the question was what T and Z in the timestamp
(for example 2019-01-31T07:24:06.100447Z
) means. In
this blog, I will discuss the timestamp format and show you how
you can change the time zone used.
Examples of the timestamps from the MySQL error log when
restarting MySQL (click to enlarge).
The MySQL 5.7 Change
In MySQL 5.7 it was decided to make two …
[Read more]