Project

General

Profile

Actions

Bug #16083

closed

Big memory usage when fetching/writing node configuration and expected reports

Added by Nicolas CHARLES about 5 years ago. Updated almost 5 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
Severity:
Major - prevents use of part of Rudder | no simple workaround
UX impact:
User visibility:
Infrequent - complex configurations | third party integrations
Effort required:
Priority:
41
Name check:
Reviewed
Fix check:
Checked
Regression:

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


Subtasks 1 (0 open1 closed)

Bug #16228: Fetching nodes last run is not batchedReleasedFrançois ARMANDActions
Actions

Also available in: Atom PDF