Enterprise Manager
Lists the Connection Activity metrics and provides a brief description of each.
Table 6.4 Connection Activity Metrics
| Name | Description |
|---|---|
| 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 Connections | The maximum number of connections that have been in use simultaneously since the server started. |
| Ongoing Anonymous Transaction Count | Shows 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 |
| Threads Cached | The number of Threads that are cached |
| Threads Current | The number of Threads that are currently running |