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