MySQL :: MySQL Performance Schema :: 10.9.2 The session_connect_attrs Table

10bet网址

version 8.0

5.7
5.6

MySQL Performance Schema/.../ The session_connect_attrs Table

10.9.2 The session_connect_attrs Table

Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, seeSection 10.9, “Performance Schema Connection Attribute Tables”.

Thesession_connect_attrstable contains connection attributes for all sessions. To see connection attributes only for the current session, and other sessions associated with the session account, use thesession_account_connect_attrstable.

Thesession_connect_attrstable has 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.

Thesession_connect_attrstable has these indexes:

Primary key on (PROCESSLIST_ID,ATTR_NAME)

TRUNCATE TABLEis not permitted for thesession_connect_attrstable.

PREV HOME UP NEXT