Documentation Home
MySQL 8.3 Reference Manual
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows


29.12.9.1 会话账户连接属性表

应用程序可以在连接时将关键值连接属性传递给服务器。有关常见属性的描述，请参阅 第 29.12.9 节，“性能模式连接属性表”。

该 session_account_connect_attrs 表仅包含当前会话和关联会话账户的连接属性。要查看所有会话的连接属性，请使用 session_connect_attrs 表。

该 session_account_connect_attrs 表具有以下列：

  • PROCESSLIST_ID

    会话的连接标识符。

  • ATTR_NAME

    属性名称。

  • ATTR_VALUE

    属性值。

  • ORDINAL_POSITION

    添加到连接属性集的顺序。

该 session_account_connect_attrs 表具有以下索引：

  • 主键在 (PROCESSLIST_ID, ATTR_NAME) 上

TRUNCATE TABLE 不允许用于 session_account_connect_attrs 表。


PREV   HOME   UP   NEXT
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 294.0Kb
Man Pages (Zip) - 409.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows