Hi Folks,
We have a date time column defined as datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6).
We use UTC on our machines. We found that changing the value of @@session.time_zone from SYSTEM to +00:00 reduced kernel calls and gave better performance in use cases that do lot of inserts/updates.
In both cases (ie +00:00 or SYSTEM) it should be using UTC time zone, right? Are there any side-effects/implications of changing the value from SYSTEM to +00:00 that I need to be aware of?
We are thinking of changing @@global.time_zone as well to +00:00.
Thanks,
Vamsi