Project

General

Profile

Actions

Bug #16083

closed

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

Added by Nicolas CHARLES over 4 years ago. Updated over 4 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 #1

Updated by Nicolas CHARLES over 4 years ago

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

Updated by Nicolas CHARLES over 4 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
Actions #3

Updated by Nicolas CHARLES over 4 years ago

  • Status changed from Pending technical review to Pending release
Actions #4

Updated by Alexis Mousset over 4 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
Actions #5

Updated by Alexis Mousset over 4 years ago

  • Name check changed from To do to Reviewed
Actions #6

Updated by Nicolas CHARLES over 4 years ago

  • Fix check changed from To do to Checked
Actions #7

Updated by Vincent MEMBRÉ over 4 years ago

  • 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: Atom PDF