MySQL Bugs: #29912: Graphs are missing unit labels

Bug #29912	Graphs are missing unit labels
Submitted:	19 Jul 2007 19:46	Modified:	28 Aug 2007 15:14
Reporter:	Harrison Fisk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S3 (Non-critical)
Version:	1.1.1	OS:	Any
Assigned to:	Joshua Ganderson	CPU Architecture:	Any
Tags:	Graphs, mer 120, units

Description:
The graphs in the dashboard display do not always have adequate unit labels.  Basically the fact they are always measured per minute (which is not an intiutive measurement amount) is the key piece of information missing, which could be easily added in the graph display.  It could also be labeled at the top of the page that the graphs are displayed on if that would be easier.

Some of the graphs which are not useful with knowledge of per minute collections:

Database Activity
KBytes In/Out
Table Locks
Temporary tables
Thread cache

How to repeat:
Look at the graphs. 
Realize you have no idea what the units really are.

Suggested fix:
Label them appropriately.

As a monitoring application, the X-axis will always be time. While could put a "Time" label on the bottom of each graph, it will use up valuable space. That's not to say that we shouldn't do it but that there is an associated cost for something most people will readily understand.

Perhaps a more significant problem is that the units change between minutes, hours, days, months, etc based on the graph duration. While these are self-labeling in that they are particular times or dates, the start and end date is missing (so non-interval graphs have little meaning). Also, if it's before noon, there is no indication if this is in 12 or 24 hour format.

After speaking with Oldag, it's still not clear to me what can be done here. I will discuss the costs of adding more information to the graphs with Gary and talk to Oldag further about adding a start and end date.

Committed to the 1.2.0 Advisor branch (r6879).

BUG#29912 - Graphs are missing unit labels

* Added unit labels for *all* graphs
* Additionally moved some graphs to display per second values 
  * Database Activity - avg statements/sec
  * InnoDB OS File Accesses - avg operations/sec
  * InnoDB Semaphores - avg waits/sec
  * InnoDB Row Details - avg rows/sec
  * Row Writes - avg rows/sec
  * Row Accesses - avg rows/sec
  * Query Cache Efficiency - avg cache ops/sec
  * Table Locks - avg locks/sec
  * KBytes In/Out - avg kbytes/sec

units are missing from query cache efficiency, query cache memory, row accesses, row writes, replication delay, sort activity, table locks, temporary tables, and thread cache.

Setting this back to QA testing again. Use the jar file, or the new enterprise update once Andy has updated it

Verified the labels are in the graphs in the 1.2.0.6932 jar file (now avaialable on the net when updating with a 1.2 build).

Added to the changelog for version 1.2.