Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
styledefault
typelist
printabletrue

Overview

This document contains the results of testing Data Import for MARC Bibliographic records at Ramsons release [ECS].
Ticket:

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyPERF-964

Jira Legacy
serverSystem Jira
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyMSEARCH-932

[ A brief introduction about the content of the page:

...

What we are testing? Provide context of the test. Is it for a new service? Is it an experiment? Is it regression test?

  • Include major things like environment settings (ECS, non-ECS, Eureka, non-Eureka, w/RW split, etc…)

...

What are the goals of the testing? Ex: Want to see the effect of using a different ec2 instance type. If regression: to see how vB compares to vA

  • Include defined SLAs, if available

...

Reference the Jira(s)

]

Summary

[ A bulleted-list of the most important and relevant observations from the test results. What are the most important things the readers need to know about this testing effort? Some suggestions

  • Comparison to previous test or release of response times or API durations

  • Any notable changes

  • Particular response time or durations

  • Service memory and/or CPU utilization

  • RDS memory and/or CPU utilization 

  • Other interesting observations

The summary points should answer the goals stated in Overview: did the test achieve the goals laid out? What goals were not met and why? SLAs were met or not?

]

Recommendations & Jiras (Optional)

[ If there are recommendations for the developers or operations team, or anything worth calling out, list them here.

  • Configuration options

  • Memory/CPU settings

  • Environment variables settings.

...

Summary

  • All Data-imports jobs finished successfully without errors.

  • Duration of data imports for creates and updates are mostly the same as was in Q release.

  • The PTF - Updates Success - 2 profile(based on rcp1: PTF - Updates Success - 6 ) was created for the RCON Ramsons release on tenant: cs00000int_0001.

  • DI duration growth correlates to the number of records imported. 

  • No memory leak is suspected for DI modules.

  • Services CPU utilization, Service memory utilization, and DB CPU utilization have the same utilization trend and values as in the Q release.

Recommendations & Jiras

  • mod-search deadlocks ticket

    Jira Legacy
    serverSystem Jira
    serverId01505d01-b853-3c2e-90f1-ee9b165564fc
    keyMSEARCH-932

Results

Test #

Data-import test

Profile

Duration

Ramsons

(rcon)

Duration

Quesnelia (qcon)

Duration

Quesnelia (qcp1)

ResultsResults

1

10k MARC BIB Create

PTF - Create 2

5 min 10 s

4 min 14 sec

6 minutes

Completed

2

25k MARC BIB Create

PTF - Create 2

10 min 30 s

9 min 41 sec

13 min 41 sec

Completed 

3

50k MARC BIB Create

PTF - Create 2

15 min 43 s

18 min 18 sec

21 min 59 sec

Completed 

4

100k MARC BIB Create

PTF - Create 2

31 min 51 s

38 min 36 sec

40 min 16 sec

Completed

5

500k MARC BIB Create

PTF - Create 2

2 hr 37 min

3 hours 30 min

3 hours 27 min

Completed

116

10k MARC BIB Update

PTF - Updates Success - 6

7 min 10 s

5 min 59 sec

10 min 27 sec

Completed

127

25k MARC BIB Update

PTF - Updates Success - 6

19 min 3 s

19 min 52 sec

23 min 16 sec

Completed

138

50k MARC BIB Update

PTF - Updates Success - 6

38 min 53 sec

37 min 53 sec

40 min 52 sec

Completed

149

100k MARC BIB Update

PTF - Updates Success - 6

1 hr 23 min

1 hrs 14 min

1 hrs 2 min

Completed

1510

500k MARC BIB Update

PTF - Updates Success - 6

6 hrs 39 min

5 hrs 31 min

Completed

Memory Utilization

Memory usage for both sets of tests (Creates and Updates) showing stable trend. Memory of all modules returned to normal state after tests finished. No memory leak suspects observed.

...

Memory usage for set of MARC BIB updates

...

CPU Utilization 

CPU Usage is stable for all modules involved for creates and updates. Most used module is mod-inventory (10%).

...

image-20250120-095642.pngImage Removed

RDS CPU Utilization 

Database CPU was stable for 10 K 205K 50 K 100 K and 500,000 records

...

image-20250120-102639.pngImage Removed

image-20250120-102800.pngImage Removedimage-20250120-095642.pngImage Added

RDS Metrics 

Database CPU was stable for 10 K 25K 50K 100 K and 500K records. As expected DB CPU reached 100% and stayed same during all tests.

DB metrics for create tests

...

Note: on 10K and 25K Create tests mod-orders was triggered. It was disabled on 50,100,500K tests. Results was not affected.

...

Note: here visible that mod-search queries is not included in top 10 queries, meaning that mod-search runtime indexing issue are fixed.

...

DB metrics for update tests

...

image-20250120-104819.png

image-20250120-104849.png

Open Search service

Open search CPU utilisation didn’t exceeds 30% on both data and master nodes, showing stable trend.

...