pingcap / pingcap/tidb

Refresh row_count of delta to stats_meta with new ways

Open
#40,113 0 comments 0 reactions 1 assignee Claimed by @xuyifangreeneyes View on GitHub
component/statistics sig/planner type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**
NA

**Describe the feature you'd like:**
[show stats_meta] command shows stats_meta data which is persisted from delta data. The current approach to dump delta data to stats_meta when the below conditions are meet.
1. modified data/count data > 1/10000
2. Every 20 * stats-lease

Requirement:
1. Change 10000 as configurable. User is able to adjust this value as their requirement.
2. refresh delta -> Dump the data to table using one query. User is able to control the refreshment of delta data.

**Describe alternatives you've considered:**
N/A

**Teachability, Documentation, Adoption, Migration Strategy:**
Users sometime want to get rough count of one table while count is little heavy if the table is large. This feature helps them to fetch the count easily like aurora.

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.