0
votes
1answer
121 views

How to set MySQL's internal time zone support?

Today MySQL at Facebook posted the following about MySQL performance: Today we found a performance problem in a completely unexpected place - if TIMESTAMP data type is being used and MySQL is ...
1
vote
3answers
565 views

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which ...
1
vote
3answers
508 views

MySQL is 2 hours behind system time

Have a FreeBSD box with MySQL server on it. The system time is correct - For Denmark (Europe/Copenhagen) currently summertime. # date Fri Jun 17 12:09:56 CEST 2011 The MySQL server has timezone ...
1
vote
2answers
395 views

change mysql timezone to UK

I want to change mysql default timezone to UK timezone, I have no access to mysql config file. Is there any way that I can do this on query level. So once the query executed then it will save date ...
1
vote
2answers
784 views

How do I make sure that BOTH my server and MYSQL have the same timezone?

Because when I create a time in Python scripts..I want it to match MYSQL's time. How do I make BOTH of them pacific time?
1
vote
1answer
345 views

How to set timezone of PHP and MySQL?

I need to set them to the same timezone.
0
votes
2answers
846 views

mySQL time incorrect

EDIT: I sheepishly fixed this my restarting mysqld. Sorry for wasing people's time Hi, My server's time is set to GMT. When I run "date" in ssh I get Sun Sep 27 23:36:39 BST 2009 However ...