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.4 ± 0.0 | 1.8 ± 0.3 | 3.1 ± 0.5 | 2.1 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.8 ± 0.0 | 4.2 ± 0.6 | 8.4 ± 0.9 | 2.4 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.4 ± 0.0 | 9.0 ± 0.6 | 16.3 ± 1.5 | 2.8 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.6 ± 0.1 | 17.3 ± 0.9 | 33.2 ± 1.8 | 3.3 |
| 4.9 ± 0.0 | 99.8 ± 0.0 | 6.6 ± 0.1 | 43.1 ± 1.3 | 82.2 ± 2.7 | 4.6 |
| 8.7 ± 0.1 | 89.1 ± 0.5 | 12.1 ± 0.0 | 77.3 ± 1.5 | 149.7 ± 1.8 | 6.7 |
| 10.5 ± 0.0 | 53.3 ± 0.3 | 14.2 ± 0.0 | 89.5 ± 1.3 | 174.0 ± 3.1 | 7.4 |
| 11.7 ± 0.0 | 23.2 ± 0.1 | 15.9 ± 0.1 | 99.6 ± 1.8 | 192.4 ± 4.4 | 7.5 |
| 12.5 ± 0.0 | 12.1 ± 0.0 | 17.3 ± 0.1 | 105.8 ± 1.7 | 201.7 ± 2.1 | 7.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 | 0.4 ± 0.0 | 1.6 ± 0.2 | 3.2 ± 0.6 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.7 ± 0.0 | 4.4 ± 0.2 | 7.7 ± 0.7 | 2.1 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.0 | 8.9 ± 0.7 | 17.2 ± 1.1 | 2.3 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.6 ± 0.1 | 17.1 ± 0.4 | 33.1 ± 2.3 | 2.7 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.5 ± 0.1 | 44.3 ± 1.2 | 83.6 ± 1.9 | 3.5 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 14.0 ± 0.3 | 93.0 ± 2.3 | 175.3 ± 7.7 | 4.6 |
| 19.5 ± 0.1 | 98.9 ± 0.1 | 31.8 ± 0.3 | 200.7 ± 1.2 | 365.1 ± 5.7 | 7.0 |
| 28.6 ± 0.0 | 57.4 ± 0.2 | 40.9 ± 0.1 | 149.1 ± 1.7 | 257.2 ± 3.0 | 9.2 |
| 30.6 ± 0.0 | 30.2 ± 0.1 | 39.2 ± 0.0 | 107.8 ± 0.3 | 162.4 ± 1.2 | 9.6 |
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.3 ± 0.0 | 1.6 ± 0.2 | 2.8 ± 0.2 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.5 ± 0.0 | 4.2 ± 0.3 | 7.9 ± 0.6 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.1 | 8.5 ± 0.6 | 16.6 ± 1.1 | 1.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.1 | 16.9 ± 0.5 | 33.7 ± 2.3 | 2.3 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.4 ± 0.0 | 42.8 ± 1.0 | 84.0 ± 3.0 | 2.9 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.8 ± 0.2 | 93.8 ± 2.6 | 175.5 ± 4.1 | 3.8 |
| 19.8 ± 0.1 | 100.0 ± 0.0 | 32.5 ± 0.2 | 208.4 ± 2.5 | 377.8 ± 3.7 | 5.5 |
| 35.2 ± 0.0 | 71.7 ± 0.1 | 60.5 ± 0.2 | 200.2 ± 1.1 | 328.9 ± 2.9 | 8.9 |
| 38.5 ± 0.0 | 38.4 ± 0.1 | 55.7 ± 0.1 | 125.3 ± 0.3 | 178.3 ± 1.1 | 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.3 ± 0.0 | 1.5 ± 0.3 | 3.1 ± 0.3 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.5 ± 0.0 | 4.2 ± 0.6 | 7.7 ± 0.9 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 0.9 ± 0.0 | 8.5 ± 0.3 | 15.8 ± 1.5 | 1.7 |
| 2.0 ± 0.1 | 100.0 ± 0.0 | 2.2 ± 0.1 | 16.6 ± 1.1 | 33.2 ± 0.9 | 1.9 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 6.2 ± 0.2 | 43.8 ± 1.1 | 83.2 ± 3.1 | 2.5 |
| 9.8 ± 0.1 | 100.0 ± 0.0 | 13.4 ± 0.1 | 91.9 ± 1.8 | 175.3 ± 4.4 | 3.3 |
| 19.7 ± 0.2 | 100.0 ± 0.0 | 31.7 ± 0.3 | 206.0 ± 3.4 | 374.7 ± 7.3 | 4.7 |
| 38.5 ± 0.1 | 78.9 ± 0.3 | 76.0 ± 0.2 | 259.9 ± 1.4 | 417.5 ± 4.9 | 8.6 |
| 42.8 ± 0.0 | 43.1 ± 0.1 | 70.7 ± 0.1 | 155.8 ± 0.6 | 219.5 ± 1.3 | 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
