Bug #40106 mySQL enterprise monitor does not count com_insert_select
Submitted: 17 Oct 2008 13:06 Modified: 30 Nov 2008 21:03
Reporter: Veli-Matti Lahtela Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Enterprise Monitor Severity:S3 (Non-critical)
Version:1.3.2.9126 OS:Linux
Assigned to: Assigned Account CPU Architecture:Any

[17 Oct 2008 13:06] Veli-Matti Lahtela
Description:
Mysql Enterprise monitor does not show inserts when the inserts are done by 
select insert. 

query:
insert into part_test select RAND()*3*3599+1224226800,RAND()*14,RAND()*65000,'blah','blaah',NOW(),NOW(),RAND()*15+64,rand()*5 from part_test limit 10 ;

It looks like that where are not writing to database.

How to repeat:

| VARIABLE_NAME     | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT        | 40688          |
| COM_INSERT_SELECT | 2710236        |
| COM_SELECT        | 2750992        |
+-------------------+----------------+
3 rows in set (0.03 sec)

mysql> select * from INFORMATION_SCHEMA.global_status where variable_name like 'com_select%' or variable_name like 'com_insert%';
+-------------------+----------------+
| VARIABLE_NAME     | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT        | 40688          |
| COM_INSERT_SELECT | 2713213        |
| COM_SELECT        | 2753970        |
+-------------------+----------------+
3 rows in set (0.03 sec)

mysql> select * from INFORMATION_SCHEMA.global_status where variable_name like 'com_select%' or variable_name like 'com_insert%';
+-------------------+----------------+
| VARIABLE_NAME     | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT        | 40688          |
| COM_INSERT_SELECT | 2721746        |
| COM_SELECT        | 2762504        |
+-------------------+----------------+

Suggested fix:
To fix display show those insertions or to count those as com_insert. See also graph attached..
[17 Oct 2008 13:07] Veli-Matti Lahtela
Database Activity

Attachment: databaseActivity.jpg (image/jpeg, text), 29.37 KiB.

[17 Oct 2008 13:08] Veli-Matti Lahtela
Affects customer ( Oli Sennhauser )
[17 Oct 2008 14:01] Darren Oldag
I'm not sure in which advisor bundle it was updated, but the latest release appears to have

((inserts+insert_selects)/60)

as the expression for the DB Activity:Inserts series.

This may or may not only be in the 2.0 bundle.
[21 Oct 2008 9:02] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior with advisors bundle 1.3.0.9144 Please indicate version of Advisors and Graphs you use.
[29 Oct 2008 17:56] Veli-Matti Lahtela
I am not able to check them now, but the advisorscript file that was installed was this: AdvisorScript-Trial-1.3.0.8976.
[31 Oct 2008 21:03] Sveta Smirnova
Thank you for the feedback.

Please update advisors to latest version, try with it and inform us if problem still exists.
[1 Dec 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".