Bug #16083
closedBig memory usage when fetching/writing node configuration and expected reports
Description
On large installation (10k+), the memory usage when writing expected reports is absurdly high; same when fetching data
We should batch these queries, because it means we are taking everything, serializing them all, and putting all theses serialization in big ldap/sql query, so we are effectively tripling (+ side effect) the memory usage at these operation
Hypothesis: batching by 200 to 500 would be sweet spot because it keeps the memory at bay, while still transfering enough data
To test this hypothesis, we need to make a parameter that can be changed (either by api, or by configuration parameter) and test several scenarios
Note: version prior 4.2 where not impacted, because we didn't manage data the same way
Updated by Nicolas CHARLES about 5 years ago
- Status changed from New to In progress
- Assignee set to Nicolas CHARLES
Updated by Nicolas CHARLES about 5 years ago
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to François ARMAND
- Pull Request set to https://github.com/Normation/rudder/pull/2569
Updated by Nicolas CHARLES about 5 years ago
- Status changed from Pending technical review to Pending release
Applied in changeset rudder|bc70f083cc300cb658536fd179a5e87b69849bdb.
Updated by Alexis Mousset about 5 years ago
- Subject changed from Big memory usage when fetching/writing ndoe configuration and expected reports to Big memory usage when fetching/writing node configuration and expected reports
Updated by Alexis Mousset about 5 years ago
- Name check changed from To do to Reviewed
Updated by Nicolas CHARLES almost 5 years ago
- Fix check changed from To do to Checked
Updated by Vincent MEMBRÉ almost 5 years ago
- Status changed from Pending release to Released
This bug has been fixed in Rudder 5.0.15 which was released today.