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 | 2.2 ± 0.1 | 5.2 ± 0.4 | 6.9 ± 0.6 | 2.4 |
| 0.5 ± 0.0 | 98.6 ± 0.4 | 4.5 ± 0.3 | 10.9 ± 0.7 | 14.0 ± 0.6 | 3.7 |
| 0.7 ± 0.0 | 75.3 ± 1.3 | 7.2 ± 0.1 | 14.1 ± 0.3 | 19.4 ± 1.3 | 5.3 |
| 0.9 ± 0.0 | 44.6 ± 0.4 | 8.5 ± 0.1 | 15.7 ± 0.5 | 23.3 ± 0.6 | 5.9 |
| 1.0 ± 0.0 | 19.6 ± 0.1 | 9.3 ± 0.1 | 16.7 ± 0.5 | 23.7 ± 0.9 | 6.4 |
| 1.0 ± 0.0 | 10.0 ± 0.1 | 9.7 ± 0.2 | 17.3 ± 0.5 | 25.1 ± 1.7 | 6.6 |
| 1.0 ± 0.0 | 5.2 ± 0.0 | 9.5 ± 0.1 | 17.1 ± 0.5 | 24.2 ± 1.2 | 6.5 |
| 1.1 ± 0.0 | 2.1 ± 0.0 | 9.8 ± 0.3 | 17.3 ± 0.5 | 25.6 ± 1.2 | 6.6 |
| 1.1 ± 0.0 | 1.1 ± 0.0 | 9.8 ± 0.1 | 17.4 ± 0.5 | 26.2 ± 1.2 | 6.6 |
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 | 2.1 ± 0.0 | 3.7 ± 0.2 | 5.4 ± 0.6 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 2.6 ± 0.1 | 6.9 ± 0.3 | 10.6 ± 0.5 | 2.2 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 3.9 ± 0.1 | 11.9 ± 0.5 | 19.3 ± 1.2 | 2.6 |
| 2.0 ± 0.0 | 99.7 ± 0.0 | 6.6 ± 0.1 | 21.9 ± 0.5 | 40.1 ± 1.8 | 3.6 |
| 3.6 ± 0.0 | 72.1 ± 0.1 | 12.3 ± 0.1 | 38.0 ± 0.7 | 67.0 ± 2.0 | 5.8 |
| 4.1 ± 0.0 | 42.0 ± 0.4 | 13.9 ± 0.1 | 43.6 ± 1.5 | 78.4 ± 3.3 | 6.4 |
| 4.5 ± 0.0 | 22.8 ± 0.1 | 14.9 ± 0.1 | 46.5 ± 0.9 | 81.8 ± 1.6 | 6.9 |
| 4.7 ± 0.0 | 9.4 ± 0.1 | 15.3 ± 0.1 | 47.8 ± 0.6 | 85.4 ± 1.6 | 7.1 |
| 4.9 ± 0.0 | 4.7 ± 0.0 | 15.4 ± 0.1 | 49.4 ± 0.7 | 86.7 ± 2.0 | 7.1 |
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 | 2.0 ± 0.0 | 3.4 ± 0.1 | 5.0 ± 0.3 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 2.2 ± 0.0 | 6.1 ± 0.3 | 9.9 ± 0.5 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 3.0 ± 0.0 | 10.6 ± 0.6 | 18.7 ± 1.3 | 2.0 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 4.8 ± 0.1 | 19.2 ± 0.3 | 35.6 ± 1.3 | 2.4 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 10.2 ± 0.2 | 48.5 ± 0.9 | 89.6 ± 2.5 | 3.4 |
| 9.5 ± 0.1 | 96.3 ± 0.1 | 19.9 ± 0.1 | 95.6 ± 2.7 | 173.9 ± 3.9 | 5.4 |
| 12.5 ± 0.0 | 63.2 ± 0.5 | 26.7 ± 0.1 | 121.4 ± 1.2 | 225.1 ± 1.8 | 6.9 |
| 14.4 ± 0.0 | 28.8 ± 0.1 | 30.4 ± 0.1 | 135.5 ± 1.7 | 250.5 ± 3.6 | 7.5 |
| 15.3 ± 0.1 | 14.9 ± 0.0 | 32.2 ± 0.1 | 139.4 ± 2.0 | 262.8 ± 4.5 | 8.1 |
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 | 2.0 ± 0.0 | 3.4 ± 0.3 | 5.0 ± 0.9 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 2.2 ± 0.0 | 6.1 ± 0.5 | 9.4 ± 0.4 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 2.6 ± 0.1 | 10.1 ± 0.4 | 17.8 ± 0.9 | 1.7 |
| 1.9 ± 0.0 | 100.0 ± 0.0 | 4.1 ± 0.1 | 19.2 ± 0.6 | 35.6 ± 0.9 | 1.9 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 8.8 ± 0.1 | 46.7 ± 0.4 | 87.0 ± 1.6 | 2.7 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 17.8 ± 0.2 | 97.4 ± 1.7 | 181.5 ± 5.9 | 3.7 |
| 19.0 ± 0.1 | 96.1 ± 0.1 | 38.6 ± 0.4 | 199.1 ± 1.5 | 359.7 ± 5.1 | 6.2 |
| 24.8 ± 0.0 | 49.8 ± 0.2 | 51.3 ± 0.2 | 229.4 ± 0.9 | 418.7 ± 7.4 | 8.1 |
| 26.5 ± 0.0 | 26.0 ± 0.1 | 55.1 ± 0.1 | 235.3 ± 1.8 | 426.2 ± 6.6 | 8.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
