Project

General

Profile

Actions

Bug #16083

closed

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

Bug #16083: Big memory usage when fetching/writing node configuration and expected reports

Added by Nicolas CHARLES about 6 years ago. Updated almost 6 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

Updated by Nicolas CHARLES about 6 years ago Actions #1

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES

Updated by Nicolas CHARLES about 6 years ago Actions #2

  • 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 6 years ago Actions #3

  • Status changed from Pending technical review to Pending release

Updated by Alexis Mousset almost 6 years ago Actions #4

  • 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 almost 6 years ago Actions #5

  • Name check changed from To do to Reviewed

Updated by Nicolas CHARLES almost 6 years ago Actions #6

  • Fix check changed from To do to Checked

Updated by Vincent MEMBRÉ almost 6 years ago Actions #7

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 5.0.15 which was released today.

Actions

Also available in: PDF Atom