21.9.7. 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 provides tables that expose this information through SQL statements:

session_account_connect_attrs: Connection attributes per for the current session
session_connect_attrs: Connection attributes for all sessions

Both tables have the same columns. The difference between them is that session_connect_attrs displays connection attributes for all sessions, whereas session_account_connect_attrs displays connections only for your own account.

PROCESSLIST_ID

The connection identifier for the session.
ATTR_NAME

The attribute name.
ATTR_VALUE

The attribute value.
ORDINAL_POSITION

The order in which the attribute was added to the set of connection attributes.