系统表介绍
session_account_connect_attrs 以KV的方式存储连接属性。 包含当前会话以及使用同样用户的连接的会话
| 列名 | 含义 |
|---|---|
| PROCESSLIST_ID | 会话连接标识符 （等同于processlist中的processlist_id） |
| ATTR_NAME | 属性名称 |
| ATTR_VALUE | 属性值 |
| ORDINAL_POSITION | 连接属性序号 |
实例
mysql> select * from session_account_connect_attrs
-> ;
+----------------+-----------------+------------+------------------+
| PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION |
+----------------+-----------------+------------+------------------+
| 339 | _os | el7 | 0 |
| 339 | _client_name | libmysql | 1 |
| 339 | _pid | 8286 | 2 |
| 339 | _client_version | 5.7.33 | 3 |
| 339 | _platform | x86_64 | 4 |
| 339 | program_name | mysql | 5 |
| 342 | _os | el7 | 0 |
| 342 | _client_name | libmysql | 1 |
| 342 | _pid | 11580 | 2 |
| 342 | _client_version | 5.7.33 | 3 |
| 342 | _platform | x86_64 | 4 |
| 342 | program_name | mysql | 5 |
| 343 | _os | el7 | 0 |
| 343 | _client_name | libmysql | 1 |
| 343 | _pid | 11872 | 2 |
| 343 | _client_version | 5.7.33 | 3 |
| 343 | _platform | x86_64 | 4 |
| 343 | program_name | mysql | 5 |
+----------------+-----------------+------------+------------------+
18 rows in set (0.00 sec)
- 查看 processlist
mysql> show processlist ;
+-----+------+-------------------+--------------------+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-------------------+--------------------+---------+------+----------+------------------+
| 339 | root | localhost | performance_schema | Query | 0 | starting | show processlist |
| 342 | root | localhost | dao | Sleep | 1304 | | NULL |
| 343 | root | localhost | NULL | Sleep | 739 | | NULL |
| 344 | dao | 192.168.2.1:49464 | NULL | Sleep | 57 | | NULL |
| 345 | dao | 192.168.2.1:49467 | performance_schema | Sleep | 57 | | NULL |
+-----+------+-------------------+--------------------+---------+------+----------+------------------+
5 rows in set (0.00 sec)