Very slow query

2006-07-21 Thread Michael Sutter
Hello everbody, I have a table in my MySQL 5.0.22 Server with this columns. +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+

[Fwd: Re: mysqld_safe and timezone settings]

2006-03-27 Thread Michael Sutter
The starting of the Server with the timezone settings works fine after setting the TZ variable. I always looked at the output from select @@global.time_zone. This was SYSTEM and so I beliefed the timezone wasn't set right on the server. Thanks and Regards Michael Thanks for the help, but th

Re: mysqld_safe and timezone settings

2006-03-27 Thread Michael Sutter
Thanks for the help, but this isn't my problem. When you start the server as shown below, the SYSTEM Timezone is used for the MySQL server. This could be seen when executing the query select @@global.time_zone on the server. Than you must get a SYSTEM in your data. The problem is that I

mysqld_safe and timezone settings

2006-03-23 Thread Michael Sutter
Hello everybody, I have a problem with replication of data from master to slave server. The problem is, that the master is in a other timezone than the slave and so inserts with using the now() function creates different values on master and slave. If I want to update on the master and use the