component/infoschemahelp wantedtype/enhancement
Repository-Metriken
- Stars
- (40.090 Stars)
- PR-Merge-Metriken
- (Durchschn. Merge 14T 4h) (346 gemergte PRs in 30 T)
Beschreibung
Description
Is your feature request related to a problem? Please describe:
Statement summary tables are memory tables and only provide performance data over recent hours. But in productive environment, we need to query earlier performance data and the data before the server restarts.
Describe the feature you'd like:
Persist statement summary tables on disk periodically. The save interval can't be too short, otherwise it will impact performance.
Describe alternatives you've considered:
- Provide a tool to extract the data and save it on other places. It's not good because it complicate deployment.
- Save the data on disks in TiDB server. It's not good because we need to define a customized format.
Score
- 2996
Mentor
- @djshow832
Contact the mentors: #tidb-challenge-program channel in TiDB Community Slack Workspace
Recommended Skills
- Golang programming
- SQL executor
- TiDB DDL
- TiKV Storage
- MySQL performance schema
Learning Materials
- Chinese: TiDB 精选技术讲解文章
- English: Awesome-Database-Learning
- Document of Statement Summary Tables