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.56 ± 0.01 | 0.76 ± 0.06 | 0.94 ± 0.02 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.57 ± 0.00 | 0.91 ± 0.01 | 1.15 ± 0.07 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.58 ± 0.00 | 1.11 ± 0.04 | 1.56 ± 0.07 | 1.3 |
| 1.6 ± 0.0 | 99.7 ± 0.1 | 0.63 ± 0.01 | 1.78 ± 0.06 | 2.72 ± 0.13 | 1.9 |
| 2.0 ± 0.0 | 98.9 ± 0.1 | 0.82 ± 0.00 | 2.27 ± 0.06 | 3.15 ± 0.05 | 2.3 |
| 2.6 ± 0.0 | 93.9 ± 0.3 | 0.96 ± 0.01 | 2.93 ± 0.06 | 3.51 ± 0.03 | 3.1 |
| 3.1 ± 0.0 | 76.1 ± 0.5 | 1.37 ± 0.05 | 3.29 ± 0.01 | 3.60 ± 0.01 | 4.1 |
| 3.7 ± 0.0 | 45.2 ± 0.3 | 1.71 ± 0.03 | 3.41 ± 0.01 | 3.64 ± 0.02 | 4.9 |
| 4.1 ± 0.0 | 24.9 ± 0.1 | 1.82 ± 0.01 | 3.42 ± 0.01 | 3.63 ± 0.02 | 5.2 |
| 4.4 ± 0.0 | 10.8 ± 0.1 | 1.92 ± 0.02 | 3.41 ± 0.01 | 3.60 ± 0.01 | 5.4 |
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.56 ± 0.00 | 0.70 ± 0.02 | 0.88 ± 0.05 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.57 ± 0.00 | 0.82 ± 0.03 | 1.01 ± 0.03 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.58 ± 0.00 | 0.96 ± 0.02 | 1.21 ± 0.03 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.62 ± 0.00 | 1.24 ± 0.02 | 1.68 ± 0.03 | 1.6 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.66 ± 0.01 | 1.42 ± 0.03 | 2.00 ± 0.05 | 1.9 |
| 2.7 ± 0.0 | 99.4 ± 0.0 | 0.75 ± 0.01 | 1.82 ± 0.03 | 2.55 ± 0.05 | 2.4 |
| 3.9 ± 0.0 | 94.1 ± 0.4 | 1.06 ± 0.01 | 2.55 ± 0.03 | 3.05 ± 0.03 | 3.7 |
| 5.0 ± 0.0 | 60.9 ± 0.3 | 1.63 ± 0.01 | 2.97 ± 0.02 | 3.30 ± 0.03 | 5.3 |
| 5.4 ± 0.0 | 32.9 ± 0.2 | 1.79 ± 0.01 | 3.09 ± 0.01 | 3.38 ± 0.01 | 5.7 |
| 5.7 ± 0.0 | 14.0 ± 0.0 | 1.85 ± 0.01 | 3.16 ± 0.01 | 3.42 ± 0.01 | 5.8 |
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.56 ± 0.00 | 0.70 ± 0.01 | 0.87 ± 0.05 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.57 ± 0.00 | 0.76 ± 0.01 | 0.94 ± 0.05 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.58 ± 0.00 | 0.84 ± 0.01 | 1.05 ± 0.03 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.61 ± 0.00 | 0.98 ± 0.01 | 1.24 ± 0.02 | 1.5 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 0.64 ± 0.00 | 1.08 ± 0.01 | 1.42 ± 0.02 | 1.7 |
| 2.8 ± 0.0 | 100.0 ± 0.0 | 0.68 ± 0.00 | 1.22 ± 0.03 | 1.63 ± 0.06 | 2.0 |
| 4.1 ± 0.0 | 99.5 ± 0.1 | 0.77 ± 0.00 | 1.59 ± 0.01 | 2.15 ± 0.04 | 2.7 |
| 7.3 ± 0.0 | 89.0 ± 0.3 | 1.13 ± 0.00 | 2.31 ± 0.01 | 2.68 ± 0.02 | 4.5 |
| 9.8 ± 0.0 | 59.6 ± 0.3 | 1.50 ± 0.00 | 2.59 ± 0.01 | 2.89 ± 0.02 | 5.6 |
| 11.5 ± 0.0 | 28.1 ± 0.0 | 1.78 ± 0.01 | 2.83 ± 0.01 | 3.11 ± 0.02 | 6.1 |
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.55 ± 0.01 | 0.69 ± 0.01 | 0.80 ± 0.08 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.56 ± 0.00 | 0.73 ± 0.01 | 0.86 ± 0.03 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.58 ± 0.00 | 0.79 ± 0.02 | 0.97 ± 0.03 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.61 ± 0.00 | 0.91 ± 0.01 | 1.15 ± 0.02 | 1.5 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.63 ± 0.00 | 0.98 ± 0.01 | 1.21 ± 0.02 | 1.6 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.67 ± 0.00 | 1.07 ± 0.01 | 1.38 ± 0.03 | 1.9 |
| 4.1 ± 0.0 | 99.9 ± 0.1 | 0.72 ± 0.00 | 1.30 ± 0.02 | 1.73 ± 0.02 | 2.4 |
| 7.7 ± 0.0 | 93.7 ± 0.2 | 0.97 ± 0.01 | 1.91 ± 0.01 | 2.28 ± 0.01 | 4.0 |
| 11.0 ± 0.1 | 67.0 ± 0.1 | 1.23 ± 0.01 | 2.16 ± 0.01 | 2.45 ± 0.01 | 5.3 |
| 13.2 ± 0.0 | 32.1 ± 0.1 | 1.40 ± 0.00 | 2.27 ± 0.01 | 2.53 ± 0.01 | 5.9 |
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.52 ± 0.01 | 0.66 ± 0.01 | 0.75 ± 0.04 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.56 ± 0.00 | 0.73 ± 0.01 | 0.85 ± 0.06 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.57 ± 0.00 | 0.77 ± 0.01 | 0.90 ± 0.03 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.61 ± 0.00 | 0.87 ± 0.01 | 1.05 ± 0.03 | 1.5 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.63 ± 0.00 | 0.91 ± 0.01 | 1.13 ± 0.04 | 1.6 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.66 ± 0.00 | 1.00 ± 0.02 | 1.25 ± 0.01 | 1.9 |
| 4.1 ± 0.0 | 99.9 ± 0.0 | 0.71 ± 0.00 | 1.18 ± 0.01 | 1.54 ± 0.02 | 2.4 |
| 7.8 ± 0.0 | 94.8 ± 0.2 | 0.88 ± 0.00 | 1.71 ± 0.01 | 2.04 ± 0.02 | 3.8 |
| 11.3 ± 0.0 | 69.2 ± 0.2 | 1.12 ± 0.00 | 1.94 ± 0.01 | 2.20 ± 0.02 | 5.1 |
| 13.5 ± 0.0 | 33.0 ± 0.1 | 1.26 ± 0.00 | 2.01 ± 0.00 | 2.25 ± 0.01 | 5.8 |
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.44 ± 0.01 | 0.65 ± 0.01 | 0.72 ± 0.04 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.53 ± 0.01 | 0.71 ± 0.01 | 0.80 ± 0.02 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.56 ± 0.00 | 0.76 ± 0.01 | 0.88 ± 0.01 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.60 ± 0.01 | 0.84 ± 0.01 | 1.01 ± 0.02 | 1.5 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.62 ± 0.00 | 0.88 ± 0.00 | 1.07 ± 0.01 | 1.6 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.66 ± 0.00 | 0.94 ± 0.01 | 1.16 ± 0.04 | 1.8 |
| 4.1 ± 0.0 | 99.9 ± 0.0 | 0.71 ± 0.00 | 1.11 ± 0.02 | 1.42 ± 0.05 | 2.3 |
| 7.8 ± 0.0 | 95.1 ± 0.1 | 0.85 ± 0.00 | 1.61 ± 0.01 | 1.88 ± 0.01 | 3.8 |
| 11.5 ± 0.0 | 69.9 ± 0.2 | 1.07 ± 0.00 | 1.80 ± 0.01 | 2.01 ± 0.01 | 5.1 |
| 13.7 ± 0.1 | 33.4 ± 0.1 | 1.20 ± 0.00 | 1.85 ± 0.01 | 2.05 ± 0.01 | 5.7 |
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
