General performance degradation on large managers

Description

On managers with hundreds of thousands of executions in the database, all executions will eventually run slower, regardless of the nature of the execution.

This happens in part due to the fact that the orchestrator makes (by design) frequent queries to search for an execution, using the execution token as a filter.

The token field is not indexed, which makes this query very slow.

Since the token field is being searched by very frequently, we should index it.

(A better alternative would be to reduce the number of times that a token lookup needs to take place, but I’m not sure how feasible that is)

Steps to Reproduce

Environment:
OS (CLI), HA cluster, cloud provider
------------------------------------

Steps to reproduce:
------------------
1.
2.
3.

Expected result:
---------------

Actual result:
-------------

Why Propose Close?

None

Activity

Show:
Barak Azulay
December 22, 2019, 10:53 AM

Lukasz, lets discuss this Jira before submitting the patch.

Assignee

Łukasz Maksymczuk

Reporter

Isaac Shabtay

Labels

None

Severity

High

Target Version

5.0.5

Premium Only

no

Found In Version

5.0

QA Owner

None

Bug Type

unknown

Customer Encountered

No

Customer Name

None

Release Notes

yes

Priority

None

Epic Link

Priority

Blocker
Configure