UCP: Persist statement summary tables on disk

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