Documentation Home
MySQL Performance Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.9Mb
PDF (A4) - 0.9Mb
HTML Download (TGZ) - 141.4Kb
HTML Download (Zip) - 159.6Kb


10.9.1 The session_account_connect_attrs Table

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. For descriptions of common attributes, see Section 10.9, “Performance Schema Connection Attribute Tables”.

The session_account_connect_attrs table contains connection attributes only for sessions for your own account. To see connection attributes for all sessions, look in the session_connect_attrs table.

The session_account_connect_attrs table contains these columns:

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

TRUNCATE TABLE is not permitted for the session_account_connect_attrs table.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.