pingcap / pingcap/tidb

Provide a best-practice / troubleshooting / Q&A doc for stats and analyze

Open
#63,396 0 comments 0 reactions 0 assignees View on GitHub
component/statistics type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
Currently, our stats user documentation does not directly answer many of the most common user questions. During ONCALL, we often receive repetitive questions about stats and analyze. For example, we have had to repeatedly answer similar questions from the user.

Some frequently asked questions include:
• How to know if the cluster’s stats are good enough?
• How to tune ANALYZE config if the cluster’s stats are not healthy?
• How to make ANALYZE faster for large or partitioned tables?
• How to estimate how long an ANALYZE will take for a big table with X rows?

Proposal:
Can we provide a best-practice / troubleshooting / Q&A document for stats, similar to the hint troubleshooting doc?
This would allow us to point users directly to a resource instead of repeatedly answering the same questions.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.