From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1GsTmK-0008Ve-SL for garchives@archives.gentoo.org; Fri, 08 Dec 2006 00:39:53 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id kB80cXgH021449; Fri, 8 Dec 2006 00:38:33 GMT Received: from mail.pnpitalia.it (85-18-21-122.ip.fastwebnet.it [85.18.21.122]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id kB80ZAcE029876 for ; Fri, 8 Dec 2006 00:35:10 GMT Received: from localhost (localhost [127.0.0.1]) by mail.pnpitalia.it (Postfix) with ESMTP id 4DD9B234001 for ; Fri, 8 Dec 2006 01:35:10 +0100 (CET) Received: from mail.pnpitalia.it ([127.0.0.1]) by localhost (db [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09831-16 for ; Fri, 8 Dec 2006 01:35:08 +0100 (CET) Received: from [192.168.4.18] (unknown [192.168.4.18]) by mail.pnpitalia.it (Postfix) with ESMTP id 9FEE57AD178 for ; Fri, 8 Dec 2006 01:35:08 +0100 (CET) Message-ID: <4578B33C.9010309@gentoo.org> Date: Fri, 08 Dec 2006 01:35:08 +0100 From: Francesco Riosa User-Agent: Mozilla Thunderbird 1.5.0.8 (X11/20061125) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-server@gentoo.org Reply-to: gentoo-server@lists.gentoo.org MIME-Version: 1.0 To: gentoo-server@lists.gentoo.org Subject: Re: [gentoo-server] [friendly reminder] sys-libs/timezone-data and MySQL References: <456FF627.9090005@gentoo.org> <20061207215501.GC17171@home.power> In-Reply-To: <20061207215501.GC17171@home.power> X-Enigmail-Version: 0.94.1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mail.pnpitalia.it X-Archives-Salt: b88da939-f82a-4526-b919-b49a232db4cf X-Archives-Hash: ea4b5000fa12f24d0e191ab19a046f8a >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 -- gentoo-server@gentoo.org mailing list