Issue #6334
closedLow applicability performance for large setups due to inefficient query of repo content
Description
Regenerate applicability (both for a repo or for a consumer) requests from mongo repo_content_units data that are not required for the calculation. This has very evident negative performance impact, as
- it puts mongo under higher load
- the task keeps redundant data in a map
Restricting the search to return just required fields only improves task performance.
Avoid checking the pkglist of the errata in other repos when calculating the applicability for a repo in the majority of cases. The collections get updated every time the repo is synced. Katello is always calculating the applicability against the synced repos only. For very old content or for copied repos there should be a fallback logic.
Added by ttereshc almost 5 years ago
Added by ttereshc almost 5 years ago
Revision 32763d4f | View on GitHub
Query only specified set of fields
Used for calculating applicability. The patch from Pavel Moravec.
Added by hyu almost 5 years ago
Revision 9f144f94 | View on GitHub
Improve the performance of calculating applicable errata
Updated by hyu almost 5 years ago
- Status changed from NEW to MODIFIED
Applied in changeset 9f144f94064b8803b2a145f729470583ad36b308.
Added by hyu over 4 years ago
Revision f3eaf8c0 | View on GitHub
Speed up the erratum pkglists query by adding a repo_id index
Updated by dalley over 4 years ago
- Status changed from MODIFIED to CLOSED - CURRENTRELEASE
Updated by ttereshc over 4 years ago
- Sprint/Milestone deleted (
Pulp RPM 3.3.0) - Tags Pulp 2 added
Updated by ttereshc over 4 years ago
- Status changed from CLOSED - CURRENTRELEASE to MODIFIED
Added by hyu over 4 years ago
Revision dab8f761 | View on GitHub
Improve the performance of calculating applicable errata
closes #6334 https://pulp.plan.io/issues/6334
(cherry picked from commit 9f144f94064b8803b2a145f729470583ad36b308)
Updated by hyu over 4 years ago
Applied in changeset dab8f761f04873920be2a79c069d022701b350c6.
Added by hyu over 4 years ago
Revision f7592994 | View on GitHub
Improve the performance of calculating applicable errata
closes #6334 https://pulp.plan.io/issues/6334
(cherry picked from commit 9f144f94064b8803b2a145f729470583ad36b308)
Updated by hyu over 4 years ago
Applied in changeset f759299454ee71008e6fc5880b904d983f6b8530.
Updated by dalley over 4 years ago
- Status changed from 5 to CLOSED - CURRENTRELEASE
Query only required set of fields for calculating applicability.
The patch from Pavel Moravec.
re #6334 https://pulp.plan.io/issues/6334