Issues with value retrieval from the INFORMATION_SCHEMA.USER_ATTRIBUTES table related to resource control

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: resource control 相关，INFORMATION_SCHEMA.USER_ATTRIBUTES 表取值问题

| username: ShawnYan

[TiDB Usage Environment] Poc
[TiDB Version] 7.1
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]

  • Description:

In version 7.1, user attributes can be viewed through the tables mysql.user and INFORMATION_SCHEMA.USER_ATTRIBUTES. However, currently, only the User_attributes field in mysql.user can display resource group information.

31
311510×665 16.2 KB

  • Previous:

Add a column user_attributes to mysql.user table to store ATTRIBUTE and COMMENT, and add a view information_schema.user_attributes for users to access user attributes.

  • Issue:

After implementing the resource control feature, should the values in INFORMATION_SCHEMA.USER_ATTRIBUTES also be updated?

https://github.com/pingcap/tidb/blob/master/executor/infoschema_reader.go#L283

For example, rename the ATTRIBUTE field in INFORMATION_SCHEMA.USER_ATTRIBUTES to metadata, and add a new field resource_group.

2
| username: redgame | Original post link

Is it a suggestion for the community? I didn’t quite understand it.

3
| username: ShawnYan | Original post link

Yes, it has been reported and is pending resolution.

4
| username: ShawnYan | Original post link

issue like:

5
| username: ShawnYan | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.