8.4 DML Statement Activity Metrics

Lists the DML Statement Activity metrics and provides a brief description of each.

Table 8.4 DML Statement Activity Metrics

NameDescription
Target NameName of the OEM Target
Call Procedure (Delta)The total number of CALL statements executed.
Change DB (Delta)The total number of USE statements executed.
Dealloc SQL (Delta)The total number of DEALLOCATE PREPARE statements executed.
Delete (Delta)The total number of DELETE statements executed.
Delete Multi (Delta)The total number of multi-table DELETE statements executed.
Do Number (Delta)The total number of DO statements executed.
Empty Query (Delta)The total number of empty queries executed.
Execute SQL (Delta)The total number of EXECUTE statements executed.
Ha Close (Delta)The total number of HANDLER CLOSE statements executed.
Ha Open (Delta)The total number of HANDLER OPEN statements executed.
Ha Read (Delta)The total number of HANDLER READ statements executed.
Help (Delta)The total number of HELP statements executed.
Insert (Delta)The total number of INSERT statements executed.
Insert Select (Delta)The total number of INSERT ... SELECT statements executed.
Load (Delta)The total number of LOAD DATA INFILE statements executed.
Lock Tables (Delta)The total number of LOCK TABLE statements executed.
Prepare SQL (Delta)The total number of PREPARE statements executed.
Replace (Delta)The total number of REPLACE statements executed.
Replace Select (Delta)The total number of REPLACE ... SELECT statements executed.
Reset (Delta)The total number of RESET statements executed.
Resignal (Delta)The total number of RESIGNAL statements executed.
Select (Delta)The total number of SELECT statements executed.
Set Option (Delta)The total number of SET statements executed.
Signal (Delta)The total number of SIGNAL statements executed.
Stmt Close (Delta)The total number of DEALLOCATE PREPARE statements, or mysql_stmt_close() calls, executed.
Stmt Execute (Delta)The total number of EXECUTE statements, or mysql_stmt_execute() calls, executed.
Stmt Fetch (Delta)The total number of mysql_stmt_fetch() calls executed.
Stmt Prepare (Delta)The total number of PREPARE statements, mysql_stmt_prepare() calls, executed.
Stmt Reprepare (Delta)The total number of re-prepare operations executed for prepared statements.
Stmt Reset (Delta)The total number of mysql_stmt_reset() calls executed.
Stmt Send Long Data (Delta)The total number of mysql_stmt_send_long_data calls executed.
Unlock Tables (Delta)The total number of UNLOCK TABLES statements executed.
Update (Delta)The total number of UPDATE statements executed.
Update Multi (Delta)The total number of multi-table UPDATE statements executed.
All INSERT Statements (Delta)The sum of INSERT and INSERT ... SELECT statements within the last interval.
All UPDATE Statements (Delta)The sum of single table and multi-table UPDATE statements within the last interval.
All REPLACE Statements (Delta)The sum of REPLACE and REPLACE ... SELECT statements within the last interval.
All DELETE statements (Delta)The sum of single table and multi-table DELETE statements within the last interval.