Bug #70729 InnoDB Buffer Pool Usage screen text should be modified

• Submitted: 25 Oct 2013 20:52
• Modified: 9 Jan 2015 10:15
• Reporter: Lynn Ferrante
• Status: Closed
• Category: MySQL Enterprise Monitor: Web
• Severity: S3 (Non-critical)
• Version: 3.0
• OS: Any
• CPU Architecture: Any
• Tags: innodb buffer pool usage graph, mem, MySQL Enterprise Monitor

[25 Oct 2013 20:52] Lynn Ferrante

Description:
It would be helpful to users if this screen indicated that with a very large buffer pool (if  an approximate size could be defined that would be best) the graph may not ever be displayed be because the buffer pool may be too large to read successfully in the time period that is allocated (2 minutes according to our documentation).  This may be particulary true on very busy systems.  Right now on this screen we do say "Note: On instances with very large buffer pools, this may take some time to run on the MySQL instance" and when the graph does not display, the error reported to the user is: "Unable to generate InnoDB Buffer Pool Usage report for selected MySQL Server (U0396) Please click Reload button".  Multiple reloads do not display the graph.

How to repeat:
Go to Reports and Graphs / InnoDB buffer pool usage.  Select a server with a large buffer pool (for example, 40 GB).  The graph is not displayed and the U0396 error is displayed.  If you Reload, the same thing occurs.  

Suggested fix:
Change test on this screen to warn users that this may occur (see above).

[28 Oct 2013 13:09] MySQL Verification Team

Hello Lynn,

Thank you for the bug report.

Thanks,
Umesh