[Nolana] Check-IN + title-level requests retest

Overview

Test goal is to assess performance of circulation check-in functionality for items with 10 TLR (title-level requests) each. Difference from the previous testing is added indexes to mod_circulation_storage.request and mod_circulation_storage.actual_cost_record in scope of CIRCSTORE-402 - Getting issue details... STATUS .

Previous test report: [Nolana] Check-IN + title-level requests

Ticket: PERF-568 - Getting issue details... STATUS

Summary

  • Load tests showed that there is still significant degradation in performance of check-in for items with 10 TLRs each and without it. Also, response time increased after indexes were added. - see Response Time Comparison.
  • Resource monitoring showed that:
  • Query plan analysis for top SQL-queries showed that indexes were not used in queries processing.

Recommendations & Jiras

As added indexes didn't change query plan of most CPU-consuming queries, CIRCSTORE-402 - Getting issue details... STATUS should be reviewed. Tests should be repeated with fixes.

Test Runs 

Test #

Test Conditions

Duration 

Load generator size (recommended)

Load generator Memory (GiB) (recommended)

Notes


1.

Baseline, Check-in with 1, 8, 25 users

30 mint3.medium3

Without TLR

2.Verification, Check-in with 1, 8, 25 usersWith 10 TLR per item


Results