7.6 Connection Configuration Metrics

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

Table 7.6 Connection Configuration Metrics

Name	Description
Back Log	The number of outstanding connection requests MySQL can have.
Connect Timeout	The number of seconds that the MySQL server waits for a connect packet before responding with 'Bad handshake'.
Init Connect	A string to be executed by the server for each client that connects.
Interactive Timeout	The number of seconds the server waits for activity on an interactive connection before closing it.
Max Connect Errors	If there are more than this number of interrupted connections from a host, that host is blocked from further connections.
Max Connections	The maximum permitted number of simultaneous client connections.
Max User Connections	The maximum number of simultaneous connections permitted to any given MySQL user account.
Net Buffer Length	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	The number of seconds to wait for more data from a connection before aborting the read.
Net Retry Count	If a read on a communication port is interrupted, retry this many times before giving up.
Net Write Timeout	The number of seconds to wait for a block to be written to a connection before aborting the write.
Offline Mode Enabled	Whether the server is in offline mode, where connected client users who do not have the SUPER privilege are disconnected on the next request.
Session Track Gtids	Enables a tracker for capturing GTIDs and returning them in the OK packet.
Session Track Schema Enabled	The server can track changes to the default schema (database) name within the current session and make this information available to the client when changes occur. This variable controls whether notification occurs.
Session Track State Change Enabled	Whether the server tracks changes to the session state and notifies the client when changes to state information occur.
Session Track System Variables	The server can track changes to the session system variables and make this information available to the client when changes occur. The variable value is a comma-separated list of variables for which to track changes. By default, notification is enabled for time_zone, autocommit, character_set_client, character_set_results, and character_set_connection.
Skip Name Resolve Enabled	Whether MySQL resolves host names when checking client connections.
Wait Timeout	The number of seconds the server waits for activity on a non-interactive connection before closing it.