Skip navigation links
MySQL 5.6 Reference Manual :: 21 MySQL Performance Schema :: 21.9 Performance Schema Table Descriptions :: 21.9.7 Performance Schema Connection Attribute Tables
21.9.8 Performance Schema Summary Tables »
Section Navigation      [Toggle]

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:

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.

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices