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 | 99.6 ± 0.5 | 5.0 ± 0.8 | 12.9 ± 1.0 | 18.9 ± 1.9 | 2.8 |
| 0.4 ± 0.0 | 76.1 ± 1.8 | 11.4 ± 0.1 | 24.1 ± 0.1 | 25.6 ± 0.2 | 5.2 |
| 0.5 ± 0.0 | 46.1 ± 1.5 | 13.8 ± 0.4 | 24.6 ± 0.1 | 26.6 ± 0.6 | 5.8 |
| 0.5 ± 0.0 | 25.1 ± 0.3 | 15.2 ± 0.7 | 24.8 ± 0.1 | 27.3 ± 0.6 | 6.3 |
| 0.5 ± 0.0 | 10.5 ± 0.2 | 16.3 ± 0.0 | 25.0 ± 0.2 | 28.0 ± 0.8 | 6.5 |
| 0.5 ± 0.0 | 5.4 ± 0.0 | 16.4 ± 0.1 | 25.1 ± 0.1 | 28.6 ± 0.8 | 6.5 |
| 0.5 ± 0.0 | 2.8 ± 0.0 | 16.5 ± 0.2 | 25.1 ± 0.2 | 28.4 ± 0.7 | 6.6 |
| 0.6 ± 0.0 | 1.1 ± 0.0 | 16.1 ± 0.3 | 24.9 ± 0.3 | 28.5 ± 0.8 | 6.5 |
| 0.6 ± 0.0 | 0.5 ± 0.0 | 16.3 ± 0.1 | 25.1 ± 0.1 | 28.6 ± 0.6 | 6.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 | 3.8 ± 0.0 | 6.5 ± 0.1 | 8.2 ± 0.5 | 1.9 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 4.5 ± 0.1 | 10.8 ± 0.3 | 15.3 ± 0.6 | 2.3 |
| 1.0 ± 0.0 | 99.8 ± 0.2 | 7.5 ± 0.2 | 18.9 ± 0.7 | 26.3 ± 1.1 | 3.2 |
| 1.7 ± 0.0 | 86.7 ± 0.4 | 13.8 ± 0.4 | 29.1 ± 0.2 | 42.7 ± 1.2 | 5.1 |
| 2.2 ± 0.0 | 44.2 ± 0.4 | 17.9 ± 0.2 | 35.0 ± 0.7 | 52.0 ± 2.6 | 6.1 |
| 2.4 ± 0.0 | 23.9 ± 0.2 | 19.9 ± 0.1 | 37.3 ± 0.9 | 55.6 ± 2.6 | 6.6 |
| 2.5 ± 0.0 | 12.4 ± 0.1 | 20.4 ± 0.1 | 37.8 ± 1.1 | 56.6 ± 1.9 | 6.7 |
| 2.6 ± 0.0 | 5.1 ± 0.0 | 20.8 ± 0.1 | 38.3 ± 0.5 | 58.6 ± 2.2 | 6.8 |
| 2.6 ± 0.0 | 2.5 ± 0.0 | 20.9 ± 0.1 | 39.4 ± 0.6 | 59.1 ± 1.3 | 6.8 |
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 | 3.7 ± 0.0 | 5.2 ± 0.3 | 6.8 ± 0.2 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 4.0 ± 0.0 | 8.3 ± 0.2 | 12.1 ± 0.4 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 4.9 ± 0.1 | 13.7 ± 0.3 | 22.8 ± 1.3 | 2.0 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 7.6 ± 0.1 | 24.1 ± 0.7 | 39.8 ± 1.1 | 2.6 |
| 4.9 ± 0.0 | 98.2 ± 0.3 | 16.9 ± 0.2 | 53.8 ± 0.5 | 96.5 ± 3.9 | 4.4 |
| 6.9 ± 0.0 | 70.0 ± 0.2 | 25.6 ± 0.2 | 76.3 ± 1.4 | 129.3 ± 4.5 | 6.1 |
| 8.0 ± 0.0 | 40.1 ± 0.3 | 28.7 ± 0.1 | 86.8 ± 1.4 | 151.8 ± 1.2 | 6.6 |
| 8.8 ± 0.0 | 17.4 ± 0.1 | 31.4 ± 0.0 | 93.3 ± 1.8 | 166.4 ± 3.8 | 7.3 |
| 9.0 ± 0.0 | 8.7 ± 0.0 | 31.9 ± 0.1 | 95.3 ± 1.2 | 163.4 ± 2.0 | 7.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 | 3.7 ± 0.0 | 5.1 ± 0.3 | 6.4 ± 0.4 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 3.9 ± 0.0 | 7.6 ± 0.4 | 11.6 ± 0.7 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 4.4 ± 0.1 | 12.1 ± 0.6 | 20.4 ± 2.1 | 1.7 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 6.0 ± 0.1 | 21.8 ± 0.1 | 38.4 ± 1.5 | 2.0 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 12.4 ± 0.1 | 50.2 ± 1.2 | 90.8 ± 2.8 | 2.9 |
| 9.8 ± 0.0 | 99.2 ± 0.1 | 24.6 ± 0.2 | 103.9 ± 3.0 | 184.7 ± 7.2 | 4.4 |
| 14.6 ± 0.1 | 74.3 ± 0.4 | 39.8 ± 0.1 | 152.5 ± 1.1 | 269.6 ± 8.1 | 6.7 |
| 16.8 ± 0.0 | 33.5 ± 0.1 | 45.2 ± 0.2 | 171.9 ± 2.0 | 305.1 ± 4.6 | 7.3 |
| 18.1 ± 0.0 | 17.6 ± 0.0 | 48.8 ± 0.0 | 177.7 ± 1.8 | 318.8 ± 3.0 | 8.0 |
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
