Bug #53193 Support diagnostics link takes a long time to generate
Submitted: 27 Apr 2010 11:05 Modified: 24 May 2010 12:36
Reporter: Bogdan Kecman Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Mark Matthews CPU Architecture:Any

[27 Apr 2010 11:05] Bogdan Kecman
Support diagnostics link takes a long time to generate report. This could take few minutes for a single server and much more for a server group. This report takes a lot of resources on the mem database and can interfere with the proper work of the MEM.

How to repeat:
Start diagnostic report

Suggested fix:
Warn user before running the report.
example warning:

This report collects .... data for server/group of servers/all servers and may take a long time to run. Be prepared for it to take several minutes.
The time to run this report will be proportional to the number of servers which you are collecting data for.

On a dedicated server for which you have not requested this information before you can expect a single server report to take: xxxxx seconds.
Performance can be improved by adjusting the configuration of the innodb_buffer_pool_size of the db server to which merlin is talking.
[13 May 2010 23:53] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build
[14 May 2010 15:38] Enterprise Tools JIRA Robot
Marcos Palacios writes: 
Verified fixed in Monitor build
[24 May 2010 12:36] MC Brown
A note has been added to the 2.2.1 changelog: 

        A warning is now provided before generating the support                                                                                            
        diagnostics information to indicate the potential time delay.