As of MySQL 5.6.6, application programs can provide key/value
connection attributes to be passed to the server at connect
time, using the
mysql_options4() C API
functions. The Performance Schema exposes this information
through these tables:
The set of connection attributes visible on a given connection may vary depending on your platform and Connector used to establish the connection.
libmysqlclient client library sets these
_client_name: The client name (
libmysqlfor the client library)
_client_version: The client library version
_os: The operating system (for example,
_platform: The machine platform (for example,
_pid: The client process ID
_thread: The client thread ID (Windows only)
Other MySQL connectors may define connection attributes:
_client_license: The connector license type (Connector/J).
_runtime_version: The Java runtime environment (JRE) version (Connector/J).
_runtime_vendor: The Java runtime environment (JRE) vendor (Connector/J).
Attribute names that begin with
reserved for MySQL itself and should not be used by client
applications. This permits new attributes to be introduced by
MySQL without colliding with application attributes.
Some MySQL clients define additional attributes: