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 | 0.7 ± 0.0 | 2.3 ± 0.2 | 4.0 ± 0.6 | 2.1 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.2 ± 0.0 | 5.0 ± 0.1 | 9.1 ± 0.7 | 2.5 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 2.0 ± 0.0 | 9.0 ± 0.2 | 17.5 ± 1.6 | 3.1 |
| 2.0 ± 0.0 | 99.2 ± 0.2 | 3.6 ± 0.1 | 18.1 ± 0.7 | 35.3 ± 0.8 | 4.2 |
| 3.2 ± 0.0 | 65.1 ± 0.6 | 5.7 ± 0.1 | 28.5 ± 0.7 | 53.9 ± 0.7 | 6.1 |
| 3.7 ± 0.0 | 36.9 ± 0.2 | 6.4 ± 0.0 | 32.3 ± 0.9 | 62.1 ± 1.7 | 6.5 |
| 4.0 ± 0.0 | 20.1 ± 0.1 | 6.9 ± 0.1 | 34.8 ± 0.8 | 67.0 ± 1.7 | 7.0 |
| 4.2 ± 0.0 | 8.3 ± 0.0 | 7.1 ± 0.1 | 36.4 ± 0.9 | 70.1 ± 2.4 | 7.1 |
| 4.3 ± 0.0 | 4.1 ± 0.0 | 7.2 ± 0.1 | 36.6 ± 1.0 | 71.0 ± 1.8 | 7.1 |
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 | 0.7 ± 0.0 | 2.1 ± 0.3 | 3.5 ± 0.4 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 1.1 ± 0.0 | 4.7 ± 0.2 | 9.5 ± 0.7 | 2.1 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.7 ± 0.0 | 8.8 ± 0.4 | 17.0 ± 1.1 | 2.3 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 3.0 ± 0.1 | 17.4 ± 0.2 | 32.7 ± 1.7 | 2.8 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 7.2 ± 0.1 | 45.1 ± 0.8 | 86.7 ± 1.5 | 3.8 |
| 9.7 ± 0.1 | 97.9 ± 0.1 | 14.9 ± 0.2 | 90.4 ± 1.6 | 172.2 ± 4.1 | 5.7 |
| 13.7 ± 0.1 | 68.9 ± 0.3 | 21.2 ± 0.2 | 123.9 ± 1.9 | 232.8 ± 5.1 | 7.6 |
| 15.5 ± 0.0 | 30.7 ± 0.1 | 23.9 ± 0.0 | 134.2 ± 2.6 | 255.7 ± 5.3 | 8.0 |
| 16.4 ± 0.0 | 15.9 ± 0.1 | 24.7 ± 0.1 | 135.8 ± 1.7 | 267.8 ± 2.3 | 8.2 |
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.6 ± 0.0 | 2.0 ± 0.2 | 4.1 ± 0.4 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 4.7 ± 0.3 | 8.3 ± 1.2 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.6 ± 0.0 | 8.2 ± 0.5 | 16.0 ± 1.1 | 1.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.8 ± 0.0 | 17.5 ± 0.6 | 33.5 ± 1.3 | 2.3 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.9 ± 0.1 | 44.6 ± 0.8 | 85.1 ± 1.9 | 3.0 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 14.6 ± 0.2 | 93.6 ± 1.4 | 174.1 ± 5.9 | 3.9 |
| 19.7 ± 0.1 | 99.6 ± 0.0 | 33.6 ± 0.4 | 206.9 ± 1.9 | 373.0 ± 9.1 | 6.1 |
| 30.4 ± 0.0 | 61.3 ± 0.1 | 50.1 ± 0.1 | 200.2 ± 1.3 | 356.5 ± 2.9 | 8.9 |
| 32.6 ± 0.0 | 32.2 ± 0.1 | 49.2 ± 0.1 | 149.5 ± 1.3 | 238.3 ± 3.0 | 9.3 |
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.6 ± 0.0 | 1.8 ± 0.3 | 3.1 ± 0.5 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.8 ± 0.0 | 4.3 ± 0.2 | 7.9 ± 1.0 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.2 ± 0.1 | 8.9 ± 0.5 | 16.5 ± 0.3 | 1.7 |
| 1.9 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.1 | 16.9 ± 0.4 | 33.5 ± 0.6 | 1.9 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.6 ± 0.0 | 45.5 ± 0.7 | 85.1 ± 2.4 | 2.5 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 14.1 ± 0.2 | 92.7 ± 0.7 | 175.6 ± 5.5 | 3.3 |
| 19.7 ± 0.2 | 100.0 ± 0.0 | 33.2 ± 0.3 | 207.3 ± 1.5 | 378.9 ± 1.8 | 4.9 |
| 36.6 ± 0.0 | 74.5 ± 0.2 | 70.1 ± 0.3 | 247.7 ± 2.5 | 414.6 ± 6.1 | 8.6 |
| 40.1 ± 0.0 | 40.2 ± 0.1 | 66.1 ± 0.0 | 158.0 ± 0.6 | 232.4 ± 1.3 | 9.3 |
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
