Bug #32133 Inconsistent graphs in MySQL Administrator
Submitted: 6 Nov 2007 0:16 Modified: 12 May 2009 12:47
Reporter: Phil Cairns Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:MacOS (Darwin 8.10.3)
Assigned to: CPU Architecture:Any
Tags: administrator, ceiling, graph

[6 Nov 2007 0:16] Phil Cairns
Description:
The graph displaying the number of SQL queries in the Health module's connection health tab seems to use the most recent value as the graph's maximum displayed value. This pushes past maxima off the top of the graph. It should use the maximum visible historical maximum as the graph's ceiling.

How to repeat:
Open the MySQL Administrator, go to the Health module, select the connection health tab. Run a few queries against the server at various rates and observe that the maximum counts will disappear off the top of the graph when the rate of queries per second drops to zero.
[6 Nov 2007 11:20] Valeriy Kravchuk
Thank you for a problem report. Please, specify the exact version of MySQL Administrator used. 1.2.12 is the latest.
[6 Nov 2007 20:54] Phil Cairns
Change Version from client library version to application version
[13 Nov 2007 8:07] Sveta Smirnova
Thank you for the report.

Either I can not understand description correctly, or I can not repeat described behaviour. Please provide screenshot showing the problem.
[13 Nov 2007 21:35] Phil Cairns
Image showing whole of graph

Attachment: Picture 1.png (image/png, text), 99.24 KiB.

[13 Nov 2007 21:36] Phil Cairns
Imag show graph with the peaks cut off

Attachment: Picture 2.png (image/png, text), 89.78 KiB.

[13 Nov 2007 21:46] Phil Cairns
The images I've attached show the graph when the query volume is high, and the same graph a little while later when the query volume is zero. I think that the program should display something similar to the first image even when the query volume is low. The maximum value should always be visible. I would like to use the graph as an indicator of performance degradation over time as the amount of data in the database rises. I'm pretty sure the Windows version does this.
[14 Nov 2007 8:33] Sveta Smirnova
file to imitate load

Attachment: bug32133.php (application/octet-stream, text), 579 bytes.

[14 Nov 2007 8:37] Sveta Smirnova
Thank you for the feedback.

Verified as described. To repeat create load with attached file.
[21 Nov 2007 0:56] Phil Cairns
I've fiddled around a bit, and I think it's just the initial (system default) values on the graph. If Min Value and Max Value are set to zero, and the Auto-Extend box is checked, it behaves appropriately. It's the same for system default traffic graph settings.
[12 May 2009 12:47] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/