MySQL Bugs: #31656: time information on graphs does not match interval specification

Bug #31656	time information on graphs does not match interval specification
Submitted:	17 Oct 2007 2:02	Modified:	24 Jul 2008 14:09
Reporter:	Monty Taylor	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S3 (Non-critical)
Version:	1.2	OS:	Any
Assigned to:	Mark Matthews	CPU Architecture:	Any
Tags:	mer 121

Description:
The service manager and agents are both on machines in new york set to EDT but the web interface is set to display Australian EST and my local PC is set to PST. 
In order to get a graph from 9 - 9:30, I had to select 19:30 - 20:00.

How to repeat:
Set up some servers with the above time zones and then try to zoom in on a graph.

Suggested fix:
The time zones should be consistent. Since the web interface is translating the display of the times for the graph, the intervals input should be of the same time zone. Or else the graph display should be set to translate to the same timezone that the interval selection widget it going to want as input. The absolute time-value correctness here is much less interesting to me than the consistency in the different areas.

I was able to reproduce this using 1.2.0.7757. I set the dashboard to eastern time and pointed it to an agent and service manager physically located on a box in Pacific time.  The default interval was 12:00 - 24:00.  When I selected 15:00 - 15:30 I got 18:00 - 18:30.  To get 15:00 - 15:30 I had to select 12:00 - 12:30.    I was not able to reproduce this bug using 1.1.1.5780.

Don't believe this is still an issue or would have heard more about it in more recent versions.

Verified fixed in 2.0.0.6068.
The graph's displayed time is the local time of the Dashboard corresponding to the requested time on the monitored server.

An entry was added to the 2.0 changelog:

The graph's displayed time was not the local time of the Dashboard corresponding to the requested time on the monitored server.