session_connect_attrs

• 表字段含义与session_account_connect_attrs表相同，但是该表是保存所有连接的连接属性表

• 表记录内容示例

admin@localhost : performance_schema 11:05:51> select * from session_connect_attrs;
+----------------+----------------------------------+---------------------+------------------+
| PROCESSLIST_ID | ATTR_NAME                        | ATTR_VALUE          | ORDINAL_POSITION |
+----------------+----------------------------------+---------------------+------------------+
|              3 | _os                              | linux-glibc2.5      |                0 |
|              3 | _client_name                    | libmysql            |                1 |
|              3 | _pid                            | 3593                |                2 |
|              3 | program_name                    | mysqld              |                3 |
|              3 | _platform                        | x86_64              |                4 |
|              3 | _client_replication_channel_name | NULL                |                5 |
|              3 | _client_role                    | binary_log_listener |                6 |
|              3 | _client_version                  | 5.7.18              |                7 |
|              4 | _os                              | linux-glibc2.5      |                0 |
|              4 | _client_name                    | libmysql            |                1 |
|              4 | _pid                            | 3766                |                2 |
|              4 | _client_version                  | 5.7.18              |                3 |
|              4 | _platform                        | x86_64              |                4 |
|              4 | program_name                    | mysql              |                5 |
+----------------+----------------------------------+---------------------+------------------+
14 rows in set (0.01 sec)

• 表结构定义

CREATE TABLE `session_connect_attrs` (
  `PROCESSLIST_ID` int(11) NOT NULL,
  `ATTR_NAME` varchar(32) COLLATE utf8_bin NOT NULL,
  `ATTR_VALUE` varchar(1024) COLLATE utf8_bin DEFAULT NULL,
  `ORDINAL_POSITION` int(11) DEFAULT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8 COLLATE=utf8_bin

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/session-connect-attrs-table.html

---

上一篇： session_account_connect_attrs表 | 下一篇： user_variables_by_thread表