V
V
vlarkanov2017-08-16 09:17:10
linux
vlarkanov, 2017-08-16 09:17:10

PerconaDB 5.7: Why is the log time incorrect?

Hello!
It costs Debian 8, PerconaDB 5.7.
Time in the system (09:15):

date
Wed Aug 16 09:15:01 MSK 2017

Time in mysql (09:15):
mysql> SELECT NOW();
+---------------------+
| NOW() |
+---------------------+
| 2017-08-16 09:15:35 |
+---------------------+
1 row in set (0.00 sec)

But in the logs, the time is 3 hours behind (06:15):
tailf /var/log/mysqld.log
2017-08-16T06:15:50.845671Z 27036 [Note] Access denied for user 'roof'@'localhost' (using password: YES)

Who is to blame and what to do?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
Ivan GiBSON, 2017-08-16
@vlarkanov

Nobody and nothing, just the time in the UTC time zone is written in the logs

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question