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 issue of lock/unlock stats #46351

Closed
Rustin170506 opened this issue Aug 23, 2023 · 0 comments
Closed

Tracking issue of lock/unlock stats #46351

Rustin170506 opened this issue Aug 23, 2023 · 0 comments
Labels
type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@Rustin170506
Copy link
Member

Rustin170506 commented Aug 23, 2023 •
edited
Loading

Feature Request

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

Original pull request: #38387

The design doc.

Describe the feature you'd like:
Sometimes performance drop due to the explained change caused by statistic info change after data changes in the table.
So we want to introduce table statistic lock/unlock function to avoid unexpected performance drop by statistic changes
@Rustin170506 Rustin170506 added the type/feature-request Categorizes issue or PR as related to a new feature. label Aug 23, 2023
@Rustin170506 Rustin170506 mentioned this issue Aug 23, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 23, 2023
@Rustin170506
executor: removed unused code (#46352)
2b766b4 
ref #46351
This was referenced Aug 24, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Aug 24, 2023
@Rustin170506
executor/lockstats: reuse the same code and return err earlier (#46382)
c9b8d9c 
ref #46351
ti-chi-bot bot pushed a commit that referenced this issue Aug 29, 2023
@Rustin170506
statistics: split lock stats handler and rewrite the insert SQL (#46403)
603a15f 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Aug 29, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 30, 2023
@Rustin170506
statistics: rewrite unlock stats handler (#46478)
187573b 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Aug 31, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 2, 2023
@Rustin170506
statistics: remove lockedTable cache (#46555)
93dce26 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 4, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 5, 2023
@Rustin170506
statistics: use session pool when locking or unlocking table stats (#…
d8dbc4f 
…46611)

ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 6, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 7, 2023
@Rustin170506
statistics: improve query locked table API memory usage (#46708)
777e6da 
ref #46351
This was referenced Sep 7, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Sep 8, 2023
@Rustin170506
planner: add privilege check for lock/unlock stats (#46742)
78d1897 
ref #46351
ti-chi-bot bot pushed a commit that referenced this issue Sep 15, 2023
@Rustin170506
planner: support lock/unlock stats of partition tables (#46768)
8b15111 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 18, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 19, 2023
@Rustin170506
statistics: add better API and better logs for lock stats (#47024)
789de8d 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 20, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 20, 2023
@Rustin170506
statistics: clean up lock info when the table is deleted (#47127)
7d4c63e 
ref #46351
This was referenced Sep 21, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Sep 22, 2023
@Rustin170506
executor: stable the show stats_locked output (#47182)
3c8fe0f 
ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 25, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 26, 2023
@Rustin170506
statistics: skip update global count and modify_count if only the par…
c25fd6f 
…tition is locked (#47259)

ref #46351
@Rustin170506 Rustin170506 mentioned this issue Sep 27, 2023
Merged
13 tasks
@ran-huang ran-huang mentioned this issue Sep 27, 2023
Merged
18 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 28, 2023
@Rustin170506
statistics: Update global count and modify_count only if partition is…
05b9786 
… not locked (#47319)

ref #46351
@ti-chi-bot ti-chi-bot mentioned this issue Sep 28, 2023
Merged
13 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Rustin170506