Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  DML Statement Activity Metrics

6.6 DML Statement Activity Metrics

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

Table 6.6 DML Statement Activity Metrics

NameDescription
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.
Prepared Statements Not Being Closed (Rate)Prepared statements may increase performance in applications that execute similar statements more than once, primarily because the query is parsed only once. Prepared statements can also reduce network traffic because it is only necessary to send the data for the parameters for each execution rather than the whole statement. However, prepared statements take time to prepare and consume memory in the MySQL server until they are closed, so it is important to use them properly. If you are not closing prepared statements when you are done with them, you are needlessly tying up memory that could be put to use in other ways.
Prepared Statements Not Being Used Effectively (Rate)Prepared statements may increase performance in applications that execute similar statements more than once, primarily because the query is parsed only once. Prepared statements can also reduce network traffic because it is only necessary to send the data for the parameters for each execution rather than the whole statement. However, prepared statements take time to prepare and consume memory in the MySQL server until they are closed, so it is important to use them properly. If you are only executing a statement a few times, the overhead of creating a prepared statement may not be worthwhile.
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.