RE: MySQL Daylight Savings Time Patch

[Jennifer Sun]

Thanks. Below is the notes from the version 5 manual, does that mean
after I patch my OS, I may need to reload the timezone tables ? How I
can determine that I have to reload the timezone tables, not might need?
Or will it hurt anything if I just reload the tables anyway? Thanks. 

 

 

Note

 

Loading the time zone information is not necessarily a one-time
operation because the information changes occasionally. For example, the
rules for Daylight Saving Time in the United States, Mexico, and parts
of Canada changed in 2007. When such changes occur, applications that
use the old rules become out of date and you may find it necessary to
reload the time zone tables to keep the information used by your MySQL
server current. See the notes at the end of this section. 

 

 

-----Original Message-----
From: Dan Buettner [mailto:drbuettner@stripped] 
Sent: Tuesday, February 20, 2007 5:03 PM
To: Chris White
Cc: mysql@stripped
Subject: Re: MySQL Daylight Savings Time Patch

 

NTP won't solve this problem for you.

 

NTP, as well as most computer clocks, know nothing about daylight
savings

time, or about time zones.  What they know is how many seconds have
elapsed

since "the epoch".  The epoch, in the case of most UNIX-based OSes, is

midnight January 1, 1970.  I think Windows is the same.  The original
Mac OS

was 1/1/1904, for example.

 

It's up to the operating system to apply rules that determine that X
number

of seconds (as reported by the clock hardware) since the epoch
translates to

some human time, based on local settings for time zone and with any
daylight

savings time rules for that time zone applied.

 

My understanding is that MySQL needs no patch, but your underlying OS
most

likely does.  I know there have been patches issued for Solaris 2.x, 9
and

10, Windows XP, and Mac OS X 10.4, and almost certainly others.

 

HTH,

Dan

 

 

On 2/20/07, Chris White <chriswhite@stripped> wrote:

> 

> Sun, Jennifer wrote:

> > Any answers for the question below ?

> >

> > Is there a DST patch for MySql 4.0.20?   Thanks.

> >

> > -----Original Message-----

> > From: dpgirago@stripped [mailto:dpgirago@stripped]

> > Sent: Friday, February 09, 2007 9:30 AM

> > To: mysql@stripped

> > Subject: MySQL Daylight Savings Time Patch

> >

> > Is there a DST patch for MySQL 4.0.x series?

> >

> > I've been getting scary emails from our sys and net admins about

> > impending

> > doom.

> >

> > Thanks,

> >

> > David

> 

> If you're using NTP then what's the problem?  Sync to one of the ntp

> pools, boom your clocks are updated, MySQL uses system time and yay.

> I'm fairly sure you could sync 500 server this way.

> 

> --

> MySQL General Mailing List

> For list archives: http://lists.mysql.com/mysql

> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

> 

>