...
Low memory on 4xLarge DB during test. this was first assumption that it’s causing slowness.
Memory on 4xLarge DB is low even when system in idle state. (±30 Gb from 120Gb available on instance type). May be due to high disk swap rate, lots of indexes and schemas
With 8xLarge DB - response times for most workflows increases from 300 ms up to few seconds. However error rate becomes lower.
with 8xLarge DB - problem with low RAM dissapered, however it’s still consuming a lot of men in idle state.
Multiple
(optimistic locking)errors was found in DB logs
Recommendations & Jiras
...
Original ticket: PERF-807 Fixed load tests of MOBIUS workflows.
Test Runs
Test # | Test Conditions | Duration | Load generator size (recommended) | Load generator Memory(GiB) (recommended) | Notes (Optional) |
Mobius baseline test | 30 mins | m5a.xlarge | 9 | 4xLarge DB | |
2. | Mobius baseline test | 30 mins | m5a.xlarge | 9 | 8xLarge DB |
...