Re: MySQL 4 timezone

At 12:50 30/04/2003 +0100, Pete Attkins wrote:
Hi,
>Hi,
>
>First, a huge "Thank you" for MySQL.
>
>Having used various versions of MySQL on Windows 2000, I have a problem=20
>with timezones. My databases absolutely must use UTC (or GMT).
>
>My master (system) environment has TZ=3DUTC.
>
>MySQL v3.53.48 uses this, as confirmed by SHOW VARIABLES;
>
>MySQL v3.53.53 and 4.0.12 are ignoring the TZ variable and instead use my=
=20
>Windows UK timezone, i.e.
>timezone=3DGMT Daylight Time

Sorry, this behavior is intentional because we found that an older
deficiency of the system c library makes our server gets 100% CPU
usage when this variable is configured on the machine environment.

The code which does this is:

/mysys/my_init.c

/* Clear the OS system variable TZ and avoid the 100% CPU usage */
_putenv( "TZ=3D" );
_tzset();

>The only workaround is to set my timezone to GMT, start the MySQL service,=
=20
>change timezone back to London...
>
>I have confirmed this by opening a command window, typing SET showing=20
>TZ=3DUTC, then
>mysqld-nt.exe --console --standalone
>
>mysql SHOW VARIABLES shows timezone=3DGMT Daylight Time.
>
>Thanks in advance,
>
>Pete Attkins
>Pete Attkins Engineering Ltd.

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano
/ /|_/ / // /\ \/ /_/ / /__ S=E3o Paulo - Brazil
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com=20


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: MySQL 4 timezone

At 12:50 30/04/2003 +0100, Pete Attkins wrote:
>Hi,
>
>First, a huge "Thank you" for MySQL.
>
>Having used various versions of MySQL on Windows 2000, I have a problem=20
>with timezones. My databases absolutely must use UTC (or GMT).
>
>My master (system) environment has TZ=3DUTC.
>
>MySQL v3.53.48 uses this, as confirmed by SHOW VARIABLES;
>
>MySQL v3.53.53 and 4.0.12 are ignoring the TZ variable and instead use my=
=20
>Windows UK timezone, i.e.
>timezone=3DGMT Daylight Time

Sorry, this behavior is intentional because we found that an older
deficiency of the system c library makes our server gets 100% CPU
usage when this variable is configured on the machine environment.

The code which does this is:

/mysys/my_init.c

/* Clear the OS system variable TZ and avoid the 100% CPU usage */
_putenv( "TZ=3D" );
_tzset();

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano
/ /|_/ / // /\ \/ /_/ / /__ S=E3o Paulo - Brazil
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com=20


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

MySQL 4 timezone

------=_NextPart_000_0005_01C30F17.11CC4510
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,

First, a huge "Thank you" for MySQL.

Having used various versions of MySQL on Windows 2000, I have a problem =
with timezones. My databases absolutely must use UTC (or GMT).

My master (system) environment has TZ=3DUTC.

MySQL v3.53.48 uses this, as confirmed by SHOW VARIABLES;

MySQL v3.53.53 and 4.0.12 are ignoring the TZ variable and instead use =
my Windows UK timezone, i.e.
timezone=3DGMT Daylight Time

The only workaround is to set my timezone to GMT, start the MySQL =
service, change timezone back to London...

I have confirmed this by opening a command window, typing SET showing =
TZ=3DUTC, then
mysqld-nt.exe --console --standalone

mysql SHOW VARIABLES shows timezone=3DGMT Daylight Time.

Thanks in advance,

Pete Attkins
Pete Attkins Engineering Ltd.
------=_NextPart_000_0005_01C30F17.11CC4510--