Bug #43989 Query Analyzer tab causes full table scan on the MEM database

• Submitted: 31 Mar 2009 16:31
• Modified: 22 May 2009 8:45
• Reporter: Diego Medina
• Status: Closed
• Category: MySQL Enterprise Monitor: Server
• Severity: S1 (Critical)
• Version: 2.1.0.1020
• OS: Any
• Assigned to: MC Brown
• CPU Architecture: Any

[31 Mar 2009 16:31] Diego Medina

Description:
If you have many servers doing quan (53 in my case) There is a query that would do a full table scan and would take a very long time

How to repeat:
1- Have 52 agents monitoring and using query analyzer for about 3 weeks
2- Have an agent doing quan on the mem database
3- Go to the Query Analyzer tab, it will take a long time to load.

[31 Mar 2009 21:09] Keith Russell

Patch installed in versions => 2.1.0.1022.

[2 Apr 2009 19:41] Diego Medina

Verified fixed on 2.1.0.1022

[22 May 2009 8:45] Tony Bedford

An entry has been added to the 2.1.0 changelog:

Accessing the Query Analyzer tab caused a full table scan to take place on the MySQL Enterprise Monitor database.