Lists the Connection configuration metrics and provides a brief description of each.
Table 5.5 Connection Configuration Metrics
Name | Description |
---|---|
Back Log (Total) | The number of outstanding connection requests MySQL can have. |
Connect Timeout (Total) | The number of seconds that the MySQL server waits for a connect packet before responding with 'Bad handshake'. |
Init Connect (Total) | A string to be executed by the server for each client that connects. |
Interactive Timeout (Total) | The number of seconds the server waits for activity on an interactive connection before closing it. |
Max Connect Errors (Total) | If there are more than this number of interrupted connections from a host, that host is blocked from further connections. |
Max Connections (Total) | The maximum permitted number of simultaneous client connections. |
Max User Connections (Total) | The maximum number of simultaneous connections permitted to any given MySQL user account. |
Net Buffer Length (Total) | Each client thread is associated with a connection buffer and result buffer. Both begin with a size given by net_buffer_length but are dynamically enlarged up to max_allowed_packet bytes as needed. |
Net Read Timeout (Total) | The number of seconds to wait for more data from a connection before aborting the read. |
Net Retry Count (Total) | If a read on a communication port is interrupted, retry this many times before giving up. |
Net Write Timeout (Total) | The number of seconds to wait for a block to be written to a connection before aborting the write. |
Skip Name Resolve Enabled (Total) | Whether MySQL should resolve host names when checking client connections. |
Wait Timeout (Total) | The number of seconds the server waits for activity on a noninteractive connection before closing it. |