Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.4Mb
PDF (A4) - 31.5Mb
PDF (RPM) - 30.0Mb
EPUB - 7.7Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.5Mb
Eclipse Doc Plugin (TGZ) - 8.2Mb
Eclipse Doc Plugin (Zip) - 10.1Mb
Man Pages (TGZ) - 180.9Kb
Man Pages (Zip) - 292.0Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  ...  /  Performance Schema Connection Attribute Tables

22.9.8 Performance Schema Connection Attribute Tables

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_options() and 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.

The libmysqlclient client library sets these attributes:

  • _client_name: The client name (libmysql for the client library)

  • _client_version: The client library version

  • _os: The operating system (for example, Linux, Win64)

  • _platform: The machine platform (for example, x86_64)

  • _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 _ are 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.

Many MySQL client programs set a program_name attribute with a value equal to the client name. For example, mysqladmin and mysqldump set program_name to mysqladmin and mysqldump, respectively.

Some MySQL clients define additional attributes:

  • mysqlbinlog defines the _client_role attribute as binary_log_listener.

  • Replication slave connections define program_name as mysqld and _client_role as binary_log_listener.

  • FEDERATED storage engine connections define program_name as mysqld and _client_role as federated_storage.

User Comments
Sign Up Login You must be logged in to post a comment.