>Hi! > >On Fri, Dec 01, 2006 at 10:30:15AM +0100, Francesco Riosa wrote: >> > after an upgrade of sys-libs/timezone-data is good advice to update the >> > mysql timezones tables too: > >Hmm... What can be affected by this? How MySQL use timezone information, >which part of timezone information may change (and so require updates of >sys-libs/timezone-data) and why these changes may be important for MySQL?
I did prepared a (possibly) decent answer then my MUA decided to crash and destroy it, must be something karmik so here there is the shortened version: sys-libs/timezone-data can change daylight saving switching day, also leap seconds, time mangling/conversion stuff in general. Strictly speaking you need to update timezone-data to have a sane system, think also at "cron"ed scripts. [TMZ] leave make suppose that most of [DTM] functions are affected. At least if your server timezone is changed in the latest timezone-data release. Running replication? Then [REP] will tell you subtly things that can happen to timestamps and UPDATE/INSERT using date functions if the servers are not in sync i.e. using the same timezone data. Clustering? No idea and I don't even want to try. Regards, Francesco [TMZ] http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html [REP] http://dev.mysql.com/doc/refman/5.0/en/replication-features.html [DTM] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -- [email protected] mailing list
