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.3 ± 0.0 | 1.9 ± 0.2 | 3.1 ± 0.6 | 2.1 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.7 ± 0.0 | 4.4 ± 0.2 | 8.7 ± 0.9 | 2.4 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.0 | 8.3 ± 0.5 | 15.6 ± 1.4 | 2.8 |
| 1.9 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.1 | 16.9 ± 0.5 | 33.2 ± 2.9 | 3.2 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.5 ± 0.1 | 44.4 ± 1.3 | 84.1 ± 1.3 | 4.3 |
| 9.8 ± 0.1 | 98.9 ± 0.0 | 13.6 ± 0.2 | 91.2 ± 2.1 | 174.3 ± 3.4 | 6.0 |
| 15.1 ± 0.0 | 76.3 ± 0.5 | 21.5 ± 0.2 | 130.8 ± 1.4 | 251.3 ± 4.8 | 7.9 |
| 17.5 ± 0.0 | 35.1 ± 0.1 | 24.3 ± 0.2 | 143.0 ± 2.7 | 273.1 ± 5.7 | 8.5 |
| 18.6 ± 0.0 | 18.1 ± 0.1 | 25.9 ± 0.1 | 144.9 ± 1.2 | 274.3 ± 3.1 | 8.7 |
num_tables = 2
| 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.8 ± 0.1 | 3.4 ± 0.5 | 2.0 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.7 ± 0.0 | 4.3 ± 0.4 | 8.4 ± 1.3 | 2.2 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.0 | 8.5 ± 0.4 | 16.1 ± 1.4 | 2.5 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.0 | 17.1 ± 0.8 | 32.5 ± 1.3 | 3.0 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.4 ± 0.1 | 43.6 ± 0.8 | 85.0 ± 1.2 | 3.9 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.9 ± 0.1 | 92.5 ± 1.1 | 173.7 ± 2.7 | 5.2 |
| 18.9 ± 0.0 | 95.3 ± 0.1 | 29.7 ± 0.1 | 183.9 ± 2.1 | 338.4 ± 5.0 | 7.6 |
| 26.1 ± 0.0 | 52.3 ± 0.3 | 36.0 ± 0.1 | 145.7 ± 1.1 | 235.9 ± 2.4 | 9.2 |
| 28.3 ± 0.0 | 27.8 ± 0.1 | 36.4 ± 0.1 | 105.1 ± 0.5 | 141.3 ± 1.3 | 9.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 | 0.3 ± 0.0 | 1.7 ± 0.2 | 3.7 ± 0.8 | 1.8 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.7 ± 0.0 | 4.6 ± 0.1 | 8.5 ± 0.9 | 2.1 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.0 | 8.2 ± 0.8 | 17.0 ± 2.1 | 2.3 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.1 | 16.8 ± 0.9 | 32.0 ± 3.4 | 2.7 |
| 5.0 ± 0.1 | 100.0 ± 0.0 | 6.4 ± 0.1 | 43.9 ± 0.9 | 82.5 ± 2.2 | 3.5 |
| 9.8 ± 0.1 | 100.0 ± 0.0 | 13.6 ± 0.2 | 91.3 ± 1.1 | 172.0 ± 4.1 | 4.5 |
| 19.7 ± 0.1 | 99.8 ± 0.0 | 32.1 ± 0.4 | 204.6 ± 2.1 | 375.5 ± 4.2 | 6.7 |
| 30.9 ± 0.1 | 62.4 ± 0.1 | 45.1 ± 0.1 | 144.7 ± 0.7 | 236.4 ± 2.5 | 9.3 |
| 33.3 ± 0.0 | 32.9 ± 0.1 | 41.3 ± 0.1 | 95.2 ± 0.4 | 136.4 ± 0.5 | 9.7 |
num_tables = 10
| 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.2 ± 0.0 | 1.7 ± 0.2 | 3.1 ± 0.6 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.6 ± 0.0 | 4.4 ± 0.2 | 8.4 ± 0.6 | 1.9 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.3 ± 0.0 | 8.2 ± 0.4 | 16.2 ± 0.3 | 2.1 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.5 ± 0.1 | 16.7 ± 0.6 | 33.0 ± 2.7 | 2.5 |
| 4.9 ± 0.1 | 100.0 ± 0.0 | 6.4 ± 0.1 | 44.3 ± 1.1 | 83.0 ± 4.5 | 3.2 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.7 ± 0.2 | 92.8 ± 2.4 | 175.0 ± 4.1 | 4.1 |
| 19.7 ± 0.1 | 100.0 ± 0.0 | 32.1 ± 0.2 | 206.7 ± 2.4 | 372.8 ± 4.4 | 6.0 |
| 33.4 ± 0.0 | 67.9 ± 0.1 | 53.0 ± 0.1 | 168.9 ± 0.7 | 274.1 ± 1.8 | 9.1 |
| 36.4 ± 0.0 | 36.0 ± 0.1 | 48.6 ± 0.1 | 107.7 ± 0.3 | 153.0 ± 1.0 | 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.2 ± 0.0 | 1.8 ± 0.4 | 3.6 ± 0.4 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.5 ± 0.0 | 4.1 ± 0.3 | 8.2 ± 0.4 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 1.2 ± 0.1 | 8.4 ± 0.3 | 15.7 ± 1.1 | 1.9 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.4 ± 0.1 | 16.9 ± 0.9 | 33.9 ± 2.5 | 2.3 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.3 ± 0.1 | 42.3 ± 0.6 | 82.1 ± 2.0 | 2.9 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.8 ± 0.2 | 93.2 ± 1.4 | 176.5 ± 4.1 | 3.8 |
| 19.7 ± 0.1 | 100.0 ± 0.0 | 32.0 ± 0.2 | 206.6 ± 0.6 | 372.5 ± 6.7 | 5.4 |
| 35.8 ± 0.0 | 73.0 ± 0.2 | 62.2 ± 0.2 | 201.4 ± 1.8 | 324.3 ± 3.6 | 8.9 |
| 39.3 ± 0.0 | 39.2 ± 0.1 | 57.1 ± 0.1 | 125.1 ± 0.6 | 176.6 ± 2.0 | 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.2 ± 0.0 | 1.5 ± 0.2 | 3.4 ± 0.7 | 1.7 |
| 0.5 ± 0.0 | 100.0 ± 0.0 | 0.4 ± 0.0 | 4.1 ± 0.4 | 7.7 ± 1.2 | 1.7 |
| 1.0 ± 0.0 | 100.0 ± 0.0 | 0.8 ± 0.0 | 8.3 ± 0.1 | 16.3 ± 0.4 | 1.7 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 2.2 ± 0.1 | 16.7 ± 0.4 | 32.7 ± 1.4 | 1.9 |
| 4.9 ± 0.0 | 100.0 ± 0.0 | 6.2 ± 0.1 | 43.2 ± 0.7 | 83.4 ± 2.9 | 2.5 |
| 9.9 ± 0.1 | 100.0 ± 0.0 | 13.6 ± 0.2 | 93.3 ± 2.6 | 176.2 ± 3.8 | 3.3 |
| 19.8 ± 0.1 | 100.0 ± 0.0 | 31.7 ± 0.2 | 206.8 ± 3.3 | 375.8 ± 2.8 | 4.7 |
| 38.9 ± 0.1 | 79.4 ± 0.3 | 76.9 ± 0.1 | 262.1 ± 2.7 | 418.3 ± 3.6 | 8.5 |
| 43.2 ± 0.0 | 43.6 ± 0.1 | 71.4 ± 0.1 | 154.8 ± 0.6 | 216.6 ± 1.6 | 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
