[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-402Getting issue details... STATUS .
Previous test report: [Nolana] Check-IN + title-level requests
Ticket: - PERF-568Getting 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:
- CPU consumption by several services increased significantly - see Service CPU Utilization.
RDS CPU Utilization increased from 15% to 72% - see RDS CPU Utilization
Database load increased two times - see Database Load
- 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-402Getting 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 min | t3.medium | 3 | Without TLR |
2. | Verification, Check-in with 1, 8, 25 users | With 10 TLR per item |