Issues
2 of 2
Orchestrator uses inefficient subquery in REPLACE to update cluster aliases
Done
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
CS0030162
is triggering
Details
Assignee
UnassignedUnassignedReporter
Sveta SmirnovaSveta SmirnovaLabels
Needs QA
YesComponents
Fix versions
Affects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
Sveta Smirnova
Sveta Smirnova
Labels
Needs QA
Yes
Components
Fix versions
Affects versions
Priority
MediumSmart Checklist
Smart Checklist
Smart Checklist
Created December 13, 2022 at 5:07 PM
Updated October 31, 2024 at 9:45 AM
Resolved January 10, 2023 at 10:39 AM
Activity
Satya BodapatiJune 6, 2023 at 8:08 AM
https://github.com/percona/orchestrator/pull/12 is reverted and https://github.com/percona/orchestrator/pull/15 is merged to trunk.
Orchestrator sends a lot of concurrent REPLACE/SELECT queries that create a lot of semaphore waits in MySQL starting from version 8.0.29. This is result of but also the issue with the Orchestrator, because it may perform same task better.
How To Repeat
See first comment in
Expected Fix
Do not send identical REPLACE queries, implement smarter logic to check servers.