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.5 ± 0.0 | 2.0 ± 0.2 | 3.4 ± 0.4 | 2.1 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 4.7 ± 0.6 | 8.6 ± 0.8 | 2.4 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.6 ± 0.0 | 8.9 ± 0.5 | 16.9 ± 1.0 | 2.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 3.0 ± 0.0 | 17.9 ± 0.5 | 35.0 ± 2.0 | 3.6 |
| 4.5 ± 0.0 | 91.6 ± 0.8 | 6.5 ± 0.1 | 38.7 ± 1.6 | 73.8 ± 2.9 | 5.7 |
| 5.5 ± 0.0 | 56.0 ± 0.4 | 7.8 ± 0.1 | 49.0 ± 1.5 | 91.0 ± 2.4 | 6.5 |
| 6.2 ± 0.0 | 31.2 ± 0.2 | 8.7 ± 0.1 | 53.7 ± 0.7 | 101.2 ± 0.7 | 6.9 |
| 6.8 ± 0.0 | 13.4 ± 0.0 | 9.6 ± 0.1 | 55.9 ± 1.0 | 109.0 ± 3.4 | 7.4 |
| 7.0 ± 0.0 | 6.7 ± 0.0 | 9.8 ± 0.1 | 59.3 ± 0.5 | 116.5 ± 1.6 | 7.5 |
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.5 ± 0.0 | 2.2 ± 0.4 | 3.8 ± 0.6 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 4.4 ± 0.3 | 8.4 ± 1.0 | 2.1 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.5 ± 0.0 | 8.5 ± 0.3 | 17.4 ± 1.4 | 2.3 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.8 ± 0.0 | 16.4 ± 0.4 | 30.5 ± 1.9 | 2.7 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 6.8 ± 0.1 | 44.7 ± 0.5 | 85.9 ± 0.5 | 3.6 |
| 9.9 ± 0.1 | 99.9 ± 0.0 | 14.4 ± 0.2 | 92.8 ± 2.6 | 173.9 ± 5.2 | 5.0 |
| 17.8 ± 0.1 | 89.9 ± 0.4 | 28.1 ± 0.2 | 167.3 ± 2.4 | 310.1 ± 2.0 | 7.6 |
| 22.0 ± 0.0 | 44.1 ± 0.1 | 32.2 ± 0.2 | 164.5 ± 1.6 | 318.8 ± 4.9 | 8.8 |
| 23.4 ± 0.1 | 22.8 ± 0.1 | 33.1 ± 0.1 | 161.1 ± 0.7 | 301.2 ± 2.9 | 9.0 |
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.4 ± 0.0 | 2.0 ± 0.2 | 3.8 ± 0.5 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.6 ± 0.0 | 4.4 ± 0.3 | 8.1 ± 0.5 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.4 ± 0.1 | 9.1 ± 0.5 | 17.0 ± 1.3 | 1.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.7 ± 0.0 | 16.9 ± 0.5 | 33.5 ± 1.6 | 2.3 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.7 ± 0.1 | 44.4 ± 1.9 | 84.4 ± 1.7 | 3.0 |
| 9.9 ± 0.0 | 100.0 ± 0.0 | 14.0 ± 0.2 | 91.5 ± 1.2 | 175.0 ± 2.9 | 3.8 |
| 19.7 ± 0.1 | 100.0 ± 0.0 | 32.9 ± 0.2 | 207.3 ± 2.0 | 373.0 ± 7.2 | 5.7 |
| 33.4 ± 0.0 | 67.7 ± 0.1 | 55.9 ± 0.2 | 196.1 ± 1.0 | 329.9 ± 3.3 | 9.0 |
| 36.2 ± 0.0 | 35.9 ± 0.0 | 52.4 ± 0.1 | 129.2 ± 0.9 | 190.4 ± 2.5 | 9.5 |
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.4 ± 0.0 | 1.8 ± 0.2 | 3.5 ± 0.7 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.6 ± 0.0 | 4.4 ± 0.4 | 8.2 ± 1.2 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.0 ± 0.0 | 8.7 ± 0.2 | 16.2 ± 0.9 | 1.7 |
| 2.0 ± 0.1 | 100.0 ± 0.0 | 2.4 ± 0.1 | 16.2 ± 1.0 | 31.6 ± 1.2 | 1.9 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 6.4 ± 0.1 | 43.1 ± 1.7 | 82.1 ± 3.0 | 2.5 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.8 ± 0.1 | 91.8 ± 0.6 | 175.3 ± 4.8 | 3.3 |
| 19.6 ± 0.1 | 100.0 ± 0.0 | 32.2 ± 0.3 | 204.6 ± 1.0 | 369.3 ± 2.0 | 4.8 |
| 37.8 ± 0.1 | 77.2 ± 0.2 | 73.5 ± 0.3 | 254.7 ± 0.8 | 414.6 ± 3.4 | 8.6 |
| 41.8 ± 0.0 | 41.9 ± 0.0 | 68.8 ± 0.1 | 154.9 ± 0.2 | 223.5 ± 1.1 | 9.4 |
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
