Bug #45313 Quan popup has only 2 tabs if the query is run once in a while

• Submitted: 3 Jun 2009 22:12
• Modified: 15 Sep 2009 16:14
• Reporter: Marcos Palacios
• Status: Can't repeat
• Category: MySQL Enterprise Monitor: Agent
• Severity: S3 (Non-critical)
• Version: 2.1.0.1018
• OS: Any
• Assigned to: Kay Roepke
• CPU Architecture: Any

[3 Jun 2009 22:12] Marcos Palacios

Description:
When a query runs only once in a while, rather than at least twice consecutively, the quan popup has only the 2 tabs 'Canonical Query' and 'Graphs'.

I reproduced this in 2 cases with 2 different tables (and on Mac OS X and Windows XP):

In one case, the 'rental' table has 16,044 rows and doing
   SELECT * FROM rental;
retrieved 1.22 MB of data. If I run it only once, and do not run it again for 10 min, we get a popup with only 2 tabs. Then if I run the same query again twice consecutively, the popup shows all 4 tabs.

In another case, the 'staff' table has 2 rows and doing
   SELECT * FROM staff;
retrieved 35.75 KB of data. If I run it only once every 10 min or so, the popup shows only 2 tabs.

So the data size makes no difference.

*NOTE*
It does not happen for ALL queries that occur with this kind of frequency. Maybe it only happens when the query requires a full table scan. Doing more research.

How to repeat:
See Description

[3 Jun 2009 22:23] Marcos Palacios

Another example query that shows only 2 tabs (i.e., not only a "select * ..." causes it):
  select actor.last_name, film.title from actor, film limit 2000;