How to synchronise MySQL's time without mysql restart?
Posted by: Shachar Amrani
Date: October 26, 2017 07:27AM

I don't know if it is possible:

On my machine I have a service to synchronise the SYSTEM time (including Time zone), and I would like the DB will synchronize with the machine clock once in a while.

When I change SYSTEM time, MySQL keep giving the old time when I use CURRENT_TIMESTAMP, It Synchronise only when I restart the MySQL service.

I would like to ask: is it possible (by update some system variable, or simmilar) to set the DB clock without a restart of the service?

I don't want to stop the DB at all.

I think that maybe a sceduled task, which run once in a while, can be set, but what should it do?


I want somthing like this:

select CURRENT_TIMESTAMP from dual; #--still shows old time

#....put here some update time code

select CURRENT_TIMESTAMP from dual; #--want it to show current time

Options: ReplyQuote


Subject
Written By
Posted
How to synchronise MySQL's time without mysql restart?
October 26, 2017 07:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.