Bug #45683 Query example is picked at random on the UI, not respecting any time range
Submitted: 23 Jun 2009 14:44 Modified: 18 Mar 2010 8:58
Reporter: Diego Medina Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Server Severity:S3 (Non-critical)
Version:2.1.0.1070 OS:Any
Assigned to: Josh Sled CPU Architecture:Any

[23 Jun 2009 14:44] Diego Medina 
Description:
If you specify a time range on the Query Analyzer tab, click on a query, and then go to the example tab, that example query will be picked at random, not respecting the time range you have on the Quan tab.

This also applies to the explain tab

How to repeat:
1- Install and start and agent and service manager
2- Enable query analyzer on the UI
3- Send two queries through the proxy port

SELECT 1;
SELECT 2;

4- Change the time range on the UI->Query Analyzer page to show only those two queries you just sent
5- Wait two minutes
6- Send these two queries through the proxy port again:
SELECT 3;
SELECT 4;
7- Go to the Service Manager
8- Click on the "apply" button to refresh the page and click on the SELECT ? query
9- Go to the Example tab
10- Do this a few times until you see
SELECT 3;
or
SELECT 4;

Which shows that the time range on the query analyzer tab is not respected.
[1 Oct 2009 20:31] Enterprise Tools JIRA Robot 
Diego Medina writes: 
Mark:
Will this do for the repo information?

{noformat}
mysql> select 
  instance_attribute_id, 
  from_unixtime(end_time / 1000)
  as date_time ,
  value   
  from 
    dc_ng_string_now 
  where value like "select%" 
  limit 2036, 1000;
+-----------------------+---------------------+----------------------------------+
| instance_attribute_id | date_time           | value                            |
+-----------------------+---------------------+----------------------------------+
|                  2354 | 2009-09-23 19:50:07 | select @@version_comment limit 1 | 
|                  2354 | 2009-09-23 20:00:17 | select @@version_comment limit 1 | 
|                 32849 | 2009-10-01 16:07:08 | SELECT                           | 
|                 32849 | 2009-10-01 16:10:11 | SELECT                           | 
|                 32852 | 2009-10-01 16:07:08 | SELECT ?                         | 
|                 32852 | 2009-10-01 16:10:11 | SELECT ?                         | 
|                 32867 | 2009-10-01 16:07:11 | SELECT                           | 
|                 32869 | 2009-10-01 16:07:11 | select 1                         | 
|                 32881 | 2009-10-01 16:07:11 | SELECT                           | 
|                 32883 | 2009-10-01 16:07:11 | select 2                         | 
|                 32898 | 2009-10-01 16:10:11 | SELECT                           | 
|                 32900 | 2009-10-01 16:10:11 | select 5                         | 
|                 32912 | 2009-10-01 16:10:11 | SELECT                           | 
|                 32914 | 2009-10-01 16:10:11 | select 6                         | 
|                 32926 | 2009-10-01 16:10:11 | SELECT                           | 
|                 32928 | 2009-10-01 16:10:11 | select 7                         | 
+-----------------------+---------------------+----------------------------------+
16 rows in set (1.78 sec)
{noformat}
[22 Feb 2010 21:07] Enterprise Tools JIRA Robot 
Josh Sled writes: 
revno: 7920
revision-id: jsled@asynchronous.org-20100222210403-ozt30y5twe9kxyu7
parent: jsled@asynchronous.org-20100222210316-595721fbg6y55dfv
committer: Josh Sled <jsled@asynchronous.org>
branch nick: local
timestamp: Mon 2010-02-22 16:04:03 -0500
message:
  EM-3395: choose the latest statement within the time range, or failing that the latest overall.
[26 Feb 2010 19:49] Enterprise Tools JIRA Robot 
Keith Russell writes: 
Patch installed in versions => 2.2.0.1633.
[8 Mar 2010 20:57] Enterprise Tools JIRA Robot 
Diego Medina writes: 
I still see this on 2.2.0.1633, 

{noformat}
mysql [127.0.0.1] {service_manager} (mem) > select   from_unixtime(timestamp / 1000) , text from statement_examples  order by 1;
+---------------------------------+----------------------------------+
| from_unixtime(timestamp / 1000) | text                             |
+---------------------------------+----------------------------------+
| 2010-03-08 11:38:16             | select @@version_comment limit 1 | 
| 2010-03-08 11:38:16             | SELECT 1                         | 
| 2010-03-08 11:38:16             | SELECT 2                         | 
| 2010-03-08 11:38:16             | select USER()                    | 
| 2010-03-08 11:49:16             | SELECT 5                         | 
| 2010-03-08 11:49:16             | SELECT 6                         | 
| 2010-03-08 11:49:16             | SELECT 11                        | 
| 2010-03-08 11:51:16             | SELECT 3                         | 
| 2010-03-08 11:51:16             | SELECT 9                         | 
+---------------------------------+----------------------------------+
9 rows in set (0.00 sec)

mysql [127.0.0.1] {service_manager} (mem) > 
{noformat}

On the popup I see SELECT 3 or SELECT 9

when I am in the range from 11:37 until 11:39
[9 Mar 2010 22:05] Enterprise Tools JIRA Robot 
Diego Medina writes: 
{noformat}
Database changed
mysql> select ii.instance_id, ii.instance_name, from_unixtime(e.timestamp / 1000) , e.text from statement_examples  AS e, inventory_instances AS ii WHERE ii.instance_id = e.instance_id order by 1;
+-------------+----------------------------------------------------------------------------------+-----------------------------------+----------------------------------+
| instance_id | instance_name                                                                    | from_unixtime(e.timestamp / 1000) | text                             |
+-------------+----------------------------------------------------------------------------------+-----------------------------------+----------------------------------+
|          72 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..2423edfc562cb923f8b66c8230f7b11e.1         | 2010-03-08 11:38:16               | select @@version_comment limit 1 | 
|          73 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.1         | 2010-03-08 11:38:16               | SELECT 1                         | 
|          73 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.1         | 2010-03-08 11:51:16               | SELECT 3                         | 
|          74 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.2         | 2010-03-08 11:38:16               | SELECT 2                         | 
|          74 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.2         | 2010-03-08 11:51:16               | SELECT 9                         | 
|          75 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..e6406ff8386f1f6e13da53282088bdcb.1         | 2010-03-08 11:38:16               | select USER()                    | 
|          76 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.3         | 2010-03-08 11:49:16               | SELECT 5                         | 
|          78 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.4         | 2010-03-08 11:49:16               | SELECT 6                         | 
|          79 | 6a1838fc-4943-4855-86f8-a2a5afcd6700..adf99d2bf60a4ec4a05eadbb6d68161b.5         | 2010-03-08 11:49:16               | SELECT 11                        | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:26:37               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:26:48               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:27:19               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:27:30               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:27:40               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:27:51               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:28:01               | SET NAMES 'utf8'                 | 
|       32769 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.5a294d5e6cf84bab5cbc18e0b950d4e4.1 | 2010-03-08 21:28:12               | SET NAMES 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:31:57               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:32:07               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:32:18               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:32:28               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:32:39               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:32:49               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:33:00               | SET DIEGO 'utf8'                 | 
|       32773 | 6a1838fc-4943-4855-86f8-a2a5afcd6700.sugarcrm.237800a8fb19ff2b9ad7b08df410a902.1 | 2010-03-08 21:33:10               | SET DIEGO 'utf8'                 | 
+-------------+----------------------------------------------------------------------------------+-----------------------------------+----------------------------------+
25 rows in set (0.06 sec)
{noformat}
[11 Mar 2010 20:21] Enterprise Tools JIRA Robot 
Josh Sled writes: 
revno: 7962
revision-id: jsled@asynchronous.org-20100311201014-k8oe166wlv48zw4v
parent: jsled@asynchronous.org-20100311201005-u9g95b9lfe3zk4ct
committer: Josh Sled <jsled@asynchronous.org>
branch nick: local
timestamp: Thu 2010-03-11 15:10:14 -0500
message:
  EM-3395: better select an example from the time range, including selecting an example in the time range from within each potential statement example "Bucket".
[11 Mar 2010 22:03] Enterprise Tools JIRA Robot 
Keith Russell writes: 
Patch available in versions => 2.2.0.1645.
[17 Mar 2010 19:50] Enterprise Tools JIRA Robot 
Diego Medina writes: 
Verified fixed on 2.2.0.1645
[18 Mar 2010 8:58] MC Brown 
A note has been added to the 2.2.0 changelog: 

        When viewing queries within the Query Analyzer, the example                                                                                         
        query shown could be taken from outside of the time range                                                                                           
        configured within the query analyzer view.