Bug #24304 REPLACE commands not counted as "database activity"

• Submitted: 14 Nov 2006 16:21
• Modified: 23 May 2007 15:27
• Reporter: Anders Karlsson
• Status: Closed
• Category: MySQL Enterprise Monitor: Web
• Severity: S3 (Non-critical)
• Version: 0.7.37 - 1.1.1.5370
• OS: Windows (Windows / Linux)
• Assigned to: Mark Leith
• CPU Architecture: Any
• Tags: mer 111

[14 Nov 2006 16:21] Anders Karlsson

Description:
The MySQL Replace command does not show up in the "database activity" graph. One of my beta customers finds this incredibly annoying, as they use REPLACE a lot. In some applications, it is the most used statement, by far, but when running those applications, there is no sign of "database activity".

How to repeat:
Run a few REPLACE commands in the monitored MySQL Server. Database activity stays low.

Suggested fix:
Add a REPLACE statistic to the database activity graph.

[16 Nov 2006 2:08] Andy Bang

Add Com_replace and Com_replace_select to the DB activity graph.  We should also add Com_insert_select in addition to Com_insert, which we already do.

[16 Nov 2006 2:17] Andy Bang

We'll do this in the 1.0.1 release.

[28 Mar 2007 19:31] Mark Leith

Re-assigning to me, fixing in the graphs is easy now

[29 Mar 2007 9:34] Mark Leith

Committed in 1.1.1.4978.

o Added a line for REPLACE activity
o Take in to account any INSERT | REPLACE ... SELECT statements (previously INSERT  ... SELECT not counted)
o Take in to account any multi table UPDATE|DELETE activity (also previously not accounted for in UPDATE | DELETE)

[9 May 2007 11:32] Carsten Segieth

- in 1.1.1.5370 I cannot see a graph for REPLACE
- also I don't see that 'INSERT INTO ... SELECT * FROM ...' is 'visible' in the INSERT graph: I inserted ~ 50000 rows using REPLACE and INSERT .. SELECT and nothing happened on the INSERT graph

[22 May 2007 20:03] Bill Weber

Verified a "Replace" line was added to the Database Activity graph in the 1.1.1.5646 advisor jar.

[23 May 2007 15:27] Peter Lavin

Added to the changelog.