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

planner: sync-stats-load is easy to timeout if TiKV is busy and then cause wrong plans #50332

Closed
qw4990 opened this issue Jan 11, 2024 · 0 comments
Closed

planner: sync-stats-load is easy to timeout if TiKV is busy and then cause wrong plans #50332

qw4990 opened this issue Jan 11, 2024 · 0 comments
Assignees
@winoros @Rustin170506
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. component/statistics sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@qw4990
Copy link
Contributor

qw4990 commented Jan 11, 2024

Enhancement

In the case below where TiKV is busy (CPU usage larger than 90%), there are 100+ sync-load-timeout errors in 50 minutes, which causes some wrong plans:
image
image
image

From @winoros A temporary solution to mitigate this issue is to increase the priority of sync-stats-load requests from NORMAL to HIGH:
image
@qw4990 qw4990 added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner component/statistics labels Jan 11, 2024
@winoros winoros mentioned this issue Jan 11, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 15, 2024
@winoros
statistics, domain: assign high priority for stats sync load (#50343)
f6f4639 
ref #50332
@winoros winoros mentioned this issue Mar 10, 2024
Merged
13 tasks
@elsa0520 elsa0520 mentioned this issue Mar 20, 2024
Merged
18 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 4, 2024
@winoros
planner, stats: assign high priority for sync load related internal S…
a44d409 
…QLs (#51636)

ref #50332
@ti-chi-bot ti-chi-bot mentioned this issue Jun 7, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot added the affects-8.1 This bug affects the 8.1.x(LTS) versions. label Jun 7, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jun 7, 2024
@ti-chi-bot
planner, stats: assign high priority for sync load related internal S…
03990e9 
…QLs (#51636) (#53880)

ref #50332
@ti-chi-bot ti-chi-bot mentioned this issue Oct 30, 2024
Open
13 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@winoros winoros

@Rustin170506 Rustin170506

Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. component/statistics sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@hawkingrei @qw4990 @winoros @Rustin170506 @ti-chi-bot