Commit Latency vs Throughput
Commit Latency vs Throughput
Analysis of how commit latency scales with achieved throughput.
Values shown as mean ± standard deviation across seeds.
num_tables = 1
| Throughput (c/s) | Success Rate (%) | P50 Latency (s) | P95 Latency (s) | P99 Latency (s) | Mean Retries |
|---|
| 0.2 ± 0.0 | 100.0 ± 0.0 | 1.1 ± 0.0 | 2.7 ± 0.2 | 4.2 ± 0.4 | 2.2 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.8 ± 0.0 | 5.5 ± 0.3 | 9.3 ± 0.9 | 2.7 |
| 1.0 ± 0.0 | 99.4 ± 0.2 | 3.0 ± 0.1 | 10.5 ± 0.5 | 17.9 ± 1.9 | 3.7 |
| 1.6 ± 0.0 | 83.5 ± 0.7 | 4.9 ± 0.1 | 16.6 ± 0.4 | 29.3 ± 1.4 | 5.4 |
| 2.0 ± 0.0 | 41.4 ± 0.3 | 6.0 ± 0.0 | 20.8 ± 0.6 | 37.2 ± 1.4 | 6.2 |
| 2.2 ± 0.0 | 22.3 ± 0.2 | 6.3 ± 0.1 | 21.8 ± 0.6 | 39.5 ± 2.4 | 6.7 |
| 2.3 ± 0.0 | 11.6 ± 0.0 | 6.6 ± 0.0 | 23.5 ± 0.9 | 42.9 ± 3.0 | 6.8 |
| 2.4 ± 0.0 | 4.8 ± 0.0 | 6.6 ± 0.0 | 23.5 ± 0.7 | 42.2 ± 2.3 | 6.9 |
| 2.5 ± 0.0 | 2.4 ± 0.0 | 6.7 ± 0.0 | 24.1 ± 0.9 | 43.0 ± 1.8 | 6.9 |
num_tables = 5
| Throughput (c/s) | Success Rate (%) | P50 Latency (s) | P95 Latency (s) | P99 Latency (s) | Mean Retries |
|---|
| 0.2 ± 0.0 | 100.0 ± 0.0 | 1.0 ± 0.0 | 2.5 ± 0.2 | 4.1 ± 0.6 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.4 ± 0.0 | 5.2 ± 0.4 | 8.7 ± 1.2 | 2.1 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 2.2 ± 0.0 | 9.2 ± 0.2 | 16.7 ± 0.8 | 2.4 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 3.7 ± 0.0 | 18.4 ± 0.3 | 33.5 ± 2.3 | 2.9 |
| 4.9 ± 0.0 | 99.3 ± 0.1 | 8.5 ± 0.0 | 45.0 ± 0.4 | 86.1 ± 1.3 | 4.5 |
| 7.8 ± 0.0 | 78.1 ± 0.4 | 13.5 ± 0.1 | 70.4 ± 1.5 | 134.5 ± 3.4 | 6.5 |
| 8.8 ± 0.0 | 44.3 ± 0.2 | 15.3 ± 0.1 | 79.8 ± 2.4 | 153.2 ± 3.6 | 6.9 |
| 9.9 ± 0.0 | 19.6 ± 0.1 | 16.9 ± 0.1 | 87.4 ± 0.8 | 163.4 ± 5.1 | 7.6 |
| 10.2 ± 0.0 | 9.9 ± 0.0 | 17.4 ± 0.1 | 89.8 ± 2.3 | 166.9 ± 8.0 | 7.7 |
num_tables = 20
| Throughput (c/s) | Success Rate (%) | P50 Latency (s) | P95 Latency (s) | P99 Latency (s) | Mean Retries |
|---|
| 0.2 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 2.6 ± 0.2 | 4.1 ± 0.3 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.2 ± 0.0 | 5.2 ± 0.3 | 9.1 ± 0.7 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 2.0 ± 0.0 | 9.5 ± 0.6 | 17.0 ± 1.0 | 1.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 3.3 ± 0.1 | 18.8 ± 0.6 | 35.2 ± 1.1 | 2.3 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 7.6 ± 0.1 | 45.2 ± 1.4 | 87.3 ± 4.0 | 3.1 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 15.7 ± 0.1 | 94.1 ± 1.3 | 174.9 ± 3.1 | 4.2 |
| 18.6 ± 0.0 | 94.7 ± 0.1 | 32.8 ± 0.2 | 187.1 ± 2.4 | 343.2 ± 6.6 | 6.7 |
| 24.1 ± 0.0 | 48.3 ± 0.1 | 41.4 ± 0.1 | 202.4 ± 1.4 | 377.8 ± 2.4 | 8.4 |
| 25.7 ± 0.1 | 25.1 ± 0.1 | 44.1 ± 0.2 | 200.6 ± 3.0 | 368.4 ± 7.1 | 8.7 |
num_tables = 50
| Throughput (c/s) | Success Rate (%) | P50 Latency (s) | P95 Latency (s) | P99 Latency (s) | Mean Retries |
|---|
| 0.2 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 2.1 ± 0.2 | 3.7 ± 0.5 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.1 ± 0.0 | 5.0 ± 0.3 | 8.6 ± 1.0 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.5 ± 0.1 | 9.0 ± 0.6 | 16.3 ± 1.4 | 1.7 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.9 ± 0.1 | 17.7 ± 1.0 | 33.8 ± 0.6 | 1.9 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 7.2 ± 0.1 | 45.7 ± 1.2 | 86.4 ± 1.1 | 2.6 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 15.0 ± 0.1 | 94.3 ± 1.1 | 176.8 ± 2.3 | 3.4 |
| 19.7 ± 0.2 | 99.9 ± 0.0 | 34.5 ± 0.5 | 209.3 ± 2.5 | 381.5 ± 5.4 | 5.2 |
| 33.8 ± 0.1 | 68.5 ± 0.2 | 63.8 ± 0.2 | 242.0 ± 1.3 | 420.3 ± 2.7 | 8.7 |
| 36.5 ± 0.0 | 36.2 ± 0.1 | 62.1 ± 0.1 | 171.8 ± 0.6 | 267.7 ± 1.8 | 9.2 |
Notes
- Latencies reported in seconds (converted from milliseconds)
- Values shown as mean ± standard deviation across multiple seeds
- Throughput = commits per second during steady-state window
- Success rate = percentage of transactions that committed successfully
- Mean retries = average number of retry attempts per committed transaction
