Arm 서버의 데이터베이스 TPS 성능은 어느정도인가요?
1. 데이터베이스별 TPS 분석
1-1. 분석 결과
| DB 종류 |
Altra MAX |
Xeon Gold 6442Y |
Xeon Gold 5520+ |
Xeon Gold 5418Y |
| MariaDB |
1,665 TPS |
1,089 TPS |
921 TPS |
2,518 TPS |
| Redis |
100,000 TPS |
110,000 TPS |
92,000 TPS |
110,000 TPS |
| RabbitMQ |
1,077 TPS |
1,045 TPS |
1,034 TPS |
1,046 TPS |
| Etcd |
34,038 TPS |
21,071 TPS |
19,048 TPS |
39,380 TPS |
| PostgreSQL |
6,338 TPS |
10,955 TPS |
10,738 TPS |
9,578 TPS |
| Ruby (SQLite) |
3,246 TPS |
4,484 TPS |
3,817 TPS |
3,521 TPS |
| MongoDB |
145.35 TPS |
381.53 TPS |
356.63 TPS |
1,342.28 TPS |
| FerretDB |
147.14 TPS |
83.29 TPS |
82.86 TPS |
144.13 TPS |
테스트 도구 및 기준
MariaDB 기준, BenchmarkSQL 도구 사용
단위 : Throughput
MariaDB (transactions/sec)
Redis (requests/sec)
RabbitMQ (msg/sec)
Etcd (requests/sec)
PostgreSQL (transactions/sec)
Ruby(SQLite) (transactions/sec)
MongoDB (ops/sec)
FerretDB (ops/sec)
1-2. 서버 종류
V-Raptor Altra, Altra Max 3GHz 128C 128T
Cache
L1: 8 MiB (Instruction) + 8 MiB (Data), L2: 128 MiB Unified
Memory
Samsung, 16G x 8개, 3200 MTz (0.3 ns)
Disk
WD Blue SA510 2.5 500GB, SATA 3.2, 6.0 Gb/s (SSD)
HGST Ultrastar DC HC520, 12TB, SATA 3.2, 6.0 Gb/s (HDD)
Intel(R) Xeon(R) Gold 6442Y, 2.6GHz, 2 Sockets, 24C 96T (4th Gen)
Cache
L1: 4 MiB, L2: 96 MiB, L3: 120 MiB
Memory
SK Hynix, 32G x 4개, 4800 MHz (0.2 ns)
Disk
SAMSUNG MZ7L3960, 960GB x 2ea, SATA 6.0 Gb/s (SATA III) (SSD)
SAMSUNG MZ7L33T8, 3.84TB x 4ea, SATA 6.0 Gb/s (SATA III) (SSD)
Intel(R) Xeon(R) Gold 5520+, 2.2GHz, 2 Sockets, 28C 112T (5th Gen)
Cache
L1: 2.2 MiB x 2, L2: 56 MiB x 2, L3: 52 MiB x 2
Memory
SK Hynix, 64G x 4개, 4800 MHz (0.2 ns)
Disk
SAMSUNG MZQL21T9HCJR-00A07, 1.92TB x 4ea, NVMe 1.4v (SSD)
Intel(R) Xeon(R) Gold 5418Y, 2.0GHz, 1 Socket, 24C 48T (4th Gen)
Cache
L1/L2/L3 - 1920 KiB / 48 MiB / 45 MiB (Unified)
Memory
Samsung, 32G x 2개, 5600 MHz (0.2 ns)
Disk
Seagate ZP500CV30002, 500GB, NVMe 1.4v (SSD)
