PDF (US Ltr)
- 0.7Mb
PDF (A4)
- 0.7Mb
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 |