Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add field explanations for TiDB mysql schema tables #16684

Open
qiancai opened this issue Mar 5, 2024 · 2 comments · May be fixed by #18318
Open

Add field explanations for TiDB mysql schema tables #16684

qiancai opened this issue Mar 5, 2024 · 2 comments · May be fixed by #18318

Comments

@qiancai
Copy link
Collaborator

qiancai commented Mar 5, 2024

Issue

The TiDB's mysql Schema document lists TiDB system tables but lacks detailed explanations of the fields within these tables. These explanations are crucial for users to comprehend these tables, particularly tables that are not compatible with MySQL, such as stats_histograms.

Request

Add field explanations for mysql schema tables.

@dveeden
Copy link
Contributor

dveeden commented Apr 5, 2024

When we do this we need to make clear that the best practice is to use statement instead of directly inspecting system tables where possible. So SHOW CREATE USER ... instead of SELECT ... FROM mysql.user... etc. This is true for both MySQL, TiDB and other databases.

@dveeden
Copy link
Contributor

dveeden commented Jul 11, 2024

It would be good to use the same page-per-table approach as is used for information_schema tables.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants