Overview
This page is created to investigate Aurora serverless performance by comparing DB xlarge, 8xlarge and Aurora serverless instance types under load running Data Import (DI) with Check-in Check-out (CICO) running as background.
Summary
Tests
Job profiles - PTF - Create 2, PTF - Updates Success - 1
| Scenario |
|---|
| DI Create 25K, DI Update 25K |
| DI Create 25K, DI Update 25K with CICO 20 users in parallel |
| CICO 20 users |
Each scenario was tests tested on next configurations:
| DB configuration | |
|---|---|
| RDS | db.r6g.xlarge |
db.r6g.8xlarge | |
| Serverless | Serverless v2 (0.5 - 128 ACUs) |
Serverless v2 (32 - 128 ACUs) | |
Results
| Process/request | RDS | Serverless | ||
|---|---|---|---|---|
| xlarge | 8xlarge | 0.5-128 ACU | 32-128 ACU | |
| DI Create | 18 min | 9 min | 11 min (-7 min) | 14 min (+5 min) |
| DI Update | 17 min | 10 min | 16 min (-1 min) | 11 min (+1 min) |
| DI Create (with CICO in parallel) | 22 min | 9 min | 20 min (-2 min) | 11 min (+2 min) |
| DI Update (with CICO in parallel) | 22 min, error | 12 min | 25 min, error* (+3 min) | 12 min (0 min) |
| CI, 95% | 0.68 | 0.718 | 0.806 (+0.126 sec) | 0.794 (+0.076 sec) |
| CO, 95% | 1.247 | 1.251 | 1.393 (+0.146 sec) | 1.312 (+0.061 sec) |
| CI (with DI Update in parallel), 95% | 1.36 | 1.193 | 1.277 (-0.083 sec) | 1.11 (-0.083 sec) |
| CO (with DI Update in parallel), 95% | 2.335 | 2.062 | 2.321 (-0.014 sec) | 1.963 (-0.099 sec) |
*Error - io.vertx.core.impl.NoStackTraceThrowable
Service CPU Utilization
db.r6g.xlarge without CICO
db.r6g.xlarge with CICO
db.r6g.8xlarge without CICO
db.r6g.8xlarge with CICO
Serverless v2 (0.5 - 128 ACUs) without CICO
Serverless v2 (0.5 - 128 ACUs) with CICO
Serverless v2 (32 - 128 ACUs) without CICO
Serverless v2 (32 - 128 ACUs) with CICO
Memory Utilization
db.r6g.xlarge without CICO
db.r6g.xlarge with CICO
db.r6g.8xlarge without CICO
db.r6g.8xlarge with CICO
Serverless v2 (0.5 - 128 ACUs) without CICO
Serverless v2 (0.5 - 128 ACUs) with CICO
Serverless v2 (32 - 128 ACUs) without CICO
Serverless v2 (32 - 128 ACUs) with CICO
DB CPU Utilization
db.r6g.xlarge without CICO
db.r6g.xlarge with CICO
db.r6g.8xlarge without CICO
db.r6g.8xlarge with CICO
Serverless v2 (0.5 - 128 ACUs) without CICO
Serverless v2 (0.5 - 128 ACUs) with CICO
Serverless v2 (32 - 128 ACUs) without CICO
Serverless v2 (32 - 128 ACUs) with CICO
DB Connections
db.r6g.xlarge without CICO
db.r6g.xlarge with CICO
db.r6g.8xlarge without CICO
db.r6g.8xlarge with CICO
Serverless v2 (0.5 - 128 ACUs) without CICO
Serverless v2 (0.5 - 128 ACUs) with CICO
Serverless v2 (32 - 128 ACUs) without CICO
Serverless v2 (32 - 128 ACUs) with CICO
