[ORCHESTRATOR] Use P_S.processlist instead of I_S.processlist table during replicas discovery
General
Escalation
General
Escalation
Description
Orchestrator uses information_schema.processlist table during discovery to determine replicas of the current instance (ReadTopologyInstanceBufferable).
8.0.14 introduced performance_schema.processlist table that, according to the documentation, has improved locking, so Orc can do better.
Environment
None
Activity
Show:
Kamil Holubicki
March 4, 2025 at 8:31 PM
9.1 emits the following warning, so implmenting this change seems to be even more important
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
Orchestrator uses information_schema.processlist table during discovery to determine replicas of the current instance (ReadTopologyInstanceBufferable).
8.0.14 introduced performance_schema.processlist table that, according to the documentation, has improved locking, so Orc can do better.