MySQL Bugs: #43564: make graph interval work for periods over 24h + optional sliding window

Bug #43564	make graph interval work for periods over 24h + optional sliding window
Submitted:	11 Mar 2009 15:40	Modified:	26 Jun 2009 13:36
Reporter:	Andrii Nikitin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S4 (Feature request)
Version:	2.0.4.7141	OS:	Any
Assigned to:	Josh Sled	CPU Architecture:	Any

Description:
If looking at merlin graphs for periods of over 24 hours you have to change from Interval to From/To and specify a fixed From and to period. That's not actually very useful.

Often we want to look at the last 7 days worth of data or the last 24 hours of data and this is tedious with the current 2.0 graphing.

Additionally it may sometimes be interesting to use the same scale but to adjust the graph start time, instead of just now.
Please consider some of this for future versions of merlin.

How to repeat:
feature request

Suggested fix:
1. interval as now: in periods of day/week/month/year, and then "number of", so we can have 1 week, 2 weeks, 52 weeks, or 24 hours.
2. period as now

Already changed in 2.1 … we now have interval options of:

5 min
15 min
30 min
1 hour
2 hour
6 hour
12 hour
1 day
2 day
4 day
1 week
2 week

But that list might change (probably drop 5 min, and probably drop 2 week due to performance issues with graphs with that much data, at least until we can get it under control).

I'd heard that good things were coming to 2.1. So pleased that this will be solved then.

verified this is in build 2.1.0.1016 (as described above)

An entry was added to the 2.1.0 changelog:

If it was desired to look at MySQL Enterprise Monitor graphs for time spans of over 24 hours, you had to change from Interval to From/To mode, and specify a fixed From and To period. This was inconvenient compared to simply specifying a greater interval.