The session_account_connect_attrs:
table was added in MariaDB 10.0 (along with many other new Performance Schema tables).
The session_account_connect_attrs
table shows connection attributes for the current session.
In MariaDB 10.0.5, applications can pass key/value connection attributes to the server when a connection is made. The session_connect_attrs and session_account_connect_attrs
tables provide access to this information, for all sessions and the current session respectively.
The C API functions mysql_options() and mysql_optionsv() are used for passing connection attributes to the server.
session_account_connect_attrs
contains the following columns:
Column | Description |
---|---|
PROCESSLIST_ID |
Session connection identifier. |
ATTR_NAME |
Attribute name. |
ATTR_VALUE |
Attribute value. |
ORDINAL_POSITION |
Order in which attribute was added to the connection attributes. |
SELECT * FROM performance_schema.session_account_connect_attrs; +----------------+-----------------+------------------+------------------+ | PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION | +----------------+-----------------+------------------+------------------+ | 45 | _os | debian-linux-gnu | 0 | | 45 | _client_name | libmysql | 1 | | 45 | _pid | 7711 | 2 | | 45 | _client_version | 10.0.5 | 3 | | 45 | _platform | x86_64 | 4 | | 45 | program_name | mysql | 5 | +----------------+-----------------+------------------+------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/performance-schema-session_account_connect_attrs-table/