Jira Legacy
| Table of Contents |
|---|
| Info | ||
|---|---|---|
| ||
Work in progress... |
...
Test | Virtual Users | Duration | Holdings per instance | API call |
1. | 1 | 30 min | greater than 300 | mod-rtac POST https://[hostName]/rtac-batch |
| 2. | 1 | 30 min | greater than 300 | edge-rtac GET https://edge-[hostName]/rtac?instanceIds=id1,id2,id3,id4,id5,id6,id7,id8,id9,id10&apikey={API_KEY}&fullPeriodicals=true |
| 3. | 1 | 30 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | edge-rtac GET https://edge-[hostName]/rtac?instanceIds=id1,id2,id3,id4,id5,id6,id7,id8,id9,id10&apikey={API_KEY}&fullPeriodicals=true |
| 4. | 1 | 30 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | mod-rtac POST https://[hostName]/rtac-batch |
| 5. | 2 | 15 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | mod-rtac POST https://[hostName]/rtac-batch |
| 6. | 20 | 15 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | mod-rtac POST https://[hostName]/rtac-batch |
| 7. | 15 | 15 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | mod-inventory-storage POST https://[hostName]/inventory-hierarchy/items-and-holdings |
| 8. | 20 | 15 min | 50 instances with a mix of 3,4,5,6,7 holdings per instance | mod-inventory-storage POST https://[hostName]/inventory-hierarchy/items-and-holdings |
Results
mod-rtac
A mod-rtac level request to get all open loans for greater than 300 holdings per instance
| POST /rtac-batch for 30 minutes | Total Instances | Total Holdings | Average | 95th %tile | Average (Honeysuckle) | Delta | ||||||||
| 1 user | 1 | 333 | 790 ms | 854 ms | 529 ms | |||||||||
| 1 user | 50 | mix of 3,4,5,6,7 | 487 ms | 516 ms | 2.57 seconds | |||||||||
| 1 user | 30 | >=10 (one has 5k) from
| 2659 ms | 2933 ms | - | - | ||||||||
| 1 user | 1 | >=10 from
| 82 ms | 86 ms | - | - |
...
| POST /rtac-batch for 15 minutes | Total Instances | Total Holdings | Average | 95th %tile | Average (Honeysuckle) | Delta |
| 2 users | 50 | mix of 3,4,5,6,7 | 538 ms | 627 ms | 2.97 seconds | |
| 20 users | 50 | mix of 3,4,5,6,7 | 3622 ms | 4194 ms | 21.75 seconds |
No errors for mod-rtac were found in CloudWatch logs
...
| POST inventory-hierarchy/items-and-holdings for 15 minutes | Total Instances | Total Holdings | Average | 95th %tile | Average (Honeysuckle) | Delta |
| 15 users | 50 | mix of 3,4,5,6,7 | 371 ms | 513 ms | 7.11 seconds | |
| 20 users | 50 | mix of 3,4,5,6,7 | 500 ms | 704 ms | 9.34 seconds |
edge-rtac
An edge-rtac level request to get all open loans for greater than 300 holdings per instance
| GET /rtac for 30 minutes | Total Instances | Total Holdings | Average | 95th %tile | Average (Honeysuckle) | Delta | ||||||||
| 1 user | 1 | 333 | 800 ms | 972 ms | 721 ms | |||||||||
| 1 user | 50 | mix of 3,4,5,6,7 | 807 ms | 1349 ms | 2.58 seconds | |||||||||
| 1 user | 50 | mix of 11,12 | 5796 ms | 10997 ms | - | - | ||||||||
| 2 users | 50 | mix of 11,12 | 6904 ms | 14619 ms | - | - | ||||||||
| 20 users | 50 | mix of 11,12 | 34725 ms | 57423 ms | - | - | ||||||||
| 1 user | 30 | >=10 (one has 5k) from
| 4887 ms | 5165 ms | - | - | ||||||||
| 50 users | 30 | >=10 (one has 5k) from
| 63966 ms | 10123 ms | - | - | ||||||||
| 1 user | 1 | >=10 (one has 5k) from
| 239 ms | 412 ms | - | - |
...
Average Time, ms | Module | Query | |
|---|---|---|---|
| 1 user | 119 ms | mod_inventory_storage | select * from get_items_and_holdings_view($1,$2) |
50 instances with a mix of 3,4,5,6,7 holdings per instance
Average Time, ms | Module | Query | |
|---|---|---|---|
| 20 users | 1057 ms | mod_inventory_storage | select * from get_items_and_holdings_view($1,$2) |
RDS CPU Utilization
1 user 1 instance with 333 holdings. CPU is around 24% which is normal.
...
15 users and 20 users for 50 instances with a mix of 3,4,5,6,7 holdings per instance. CPU Utilization is relatively high but this is rare. This use case was run to recreate the issue reported in MODRTAC-53
.
Appendix
Backend:
- mod-circulation-19.2.3
- mod-circulation-storage-12.1.2
- mod-inventory-storage-19.4.3
- mod-inventory-16.1.0
- okapi-4.2.2
- mod-authtoken-2.6.0
- mod-permissions-5.12.2
...