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.

Sign up for GitHub

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

Jump to bottom

Tracking for statscache lru #34052

Closed
Yisaer opened this issue Apr 18, 2022 · 0 comments
Closed

Tracking for statscache lru #34052

Yisaer opened this issue Apr 18, 2022 · 0 comments
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@Yisaer
Copy link
Contributor

Yisaer commented Apr 18, 2022 •
edited
Loading

Enhancement

detailed design

Currently we have maintained cmsketch for both index and columns. Later we will try to maintain topn and histogram and statsCache.

If the topn of one column is evicted, we will try to use histogram instead. If the bounds in histogram is evicted, we may need use pesudo column instead. In future, I think we can use ndv or other things instead.
@Yisaer Yisaer added the type/enhancement The issue or PR belongs to an enhancement. label Apr 18, 2022
This was referenced Apr 18, 2022
Merged
Closed
This was referenced Apr 25, 2022
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue Apr 28, 2022
@Yisaer
statistics: separte Get/Put according to query for statsCacheInner (#…
42089cd 
…34211)

ref #34052
@Yisaer Yisaer mentioned this issue Apr 28, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue May 6, 2022
@Yisaer
statistics: add lru cache implement for statsCacheInner (#34323)
0f0a2ca 
ref #34052
@Yisaer Yisaer mentioned this issue May 11, 2022
Merged
4 tasks
ti-chi-bot pushed a commit that referenced this issue May 11, 2022
@Yisaer
statistics: add metrics for statscache lru (#34568)
ea4fda5 
ref #34052
@Yisaer Yisaer mentioned this issue May 13, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue May 13, 2022
@Yisaer
executor: add test cover Analyze task for evicted index (#34622)
5ca2427 
ref #34052
This was referenced May 13, 2022
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue May 13, 2022
@Yisaer
config: add unit test for assert tidb_stats_cache_mem_quota (#34633)
ad53ac2 
ref #34052
ti-chi-bot pushed a commit that referenced this issue May 15, 2022
@Yisaer
statistics: analyzed table by manual should be updated in lru (#34637)
bb66294 
ref #34052
This was referenced May 16, 2022
Merged
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue May 18, 2022
@Yisaer
variable: revise TiDBStatsCacheMemQuota settting code (#34762)
95e359f 
ref #34052
@Yisaer Yisaer mentioned this issue May 20, 2022
Merged
4 tasks
ti-chi-bot pushed a commit that referenced this issue May 23, 2022
@Yisaer
statistics: revise SaveStatsToStorage param (#34855)
0cf93b5 
ref #34052
ti-chi-bot pushed a commit that referenced this issue May 24, 2022
@Yisaer
statistics: revise statscache lru implementation (#34683)
b08e89e 
ref #34052
This was referenced Jun 2, 2022
Merged
Merged
This was referenced Jun 13, 2022
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue Jun 15, 2022
@Yisaer
statistics: revise loaded for column (#35361)
07c9e03 
ref #34052
ti-chi-bot pushed a commit that referenced this issue Jun 17, 2022
@Yisaer
statistics: handle topn reference if it is nil (#35328)
945d7ef 
ref #34052
ti-chi-bot pushed a commit that referenced this issue Jun 17, 2022
@Yisaer
statistics: support tracking column cmsketch (#35135)
9652651 
ref #34052
@Yisaer Yisaer mentioned this issue Jun 20, 2022
Merged
7 tasks
@Yisaer Yisaer mentioned this issue Jun 28, 2022
Closed
ti-chi-bot pushed a commit that referenced this issue Jul 13, 2022
@Yisaer
statistics: support tracking topn in statsCache (#35510)
da1b82a 
ref #34052
@Yisaer Yisaer mentioned this issue Jul 13, 2022
Merged
2 tasks
ti-chi-bot pushed a commit that referenced this issue Jul 28, 2022
@Yisaer
statistics: support tracking histogram (#36170)
212d62e 
ref #34052
@Yisaer Yisaer closed this as completed Jul 29, 2022
@Yisaer Yisaer mentioned this issue Aug 2, 2022
Merged
1 task
ti-chi-bot pushed a commit that referenced this issue Aug 22, 2022
@Yisaer
doc: add design doc for stats lru cache (#36804)
aaf0613 
ref #34052
@xuyifangreeneyes xuyifangreeneyes mentioned this issue May 25, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue May 25, 2023
@xuyifangreeneyes
statistics: show stats mem usage even if stats mem quota is not set (#…
b56c5b6 
…44177)

ref #34052
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Yisaer