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


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

6.4 Connection Activity Metrics

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

Table 6.4 Connection Activity Metrics

NameDescription
Aborted Clients (Delta)The number of connections that were aborted because the client died without closing the connection properly.
Aborted Connects (Delta)The number of failed attempts to connect to the MySQL server.
Bytes Received (Delta)The number of bytes received from all clients.
Bytes Sent (Delta)The number of bytes sent to all clients.
Connections (Delta)The number of connection attempts (successful or not) to the MySQL server.
Locked Connects (Delta)The number of attempts to connect to locked user accounts.
Max Execution Time Exceeded (Delta)The number of SELECT statements for which the execution timeout was exceeded.
Max Execution Time Set (Delta)The number of SELECT statements for which a nonzero execution timeout was set. This includes statements that include a nonzero MAX_EXECUTION_TIME optimizer hint, and statements that include no such hint but execute while the timeout indicated by the max_execution_time system variable is nonzero.
Max Execution Time Set Failed (Delta)The number of SELECT statements for which the attempt to set an execution timeout failed.
Max Used ConnectionsThe maximum number of connections that have been in use simultaneously since the server started.
Ongoing Anonymous Transaction CountShows the number of ongoing transactions which have been marked as anonymous. This can be used to ensure that no further transactions are waiting to be processed.
Failed Attempted Connections To The Server (Rate)Excess aborted connection attempts to MySQL may indicate an issue with respect to the server or network, or be indicative of DoS or password-cracking attempts against the MySQL Server. The aborted-connects count is incremented when: A client does not have privileges to access a database A client uses the wrong password A malformed packet is received The connect_timeout variable is exceeded