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.78 ± 0.01 | 1.75 ± 0.29 | 4.69 ± 0.76 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.79 ± 0.01 | 3.31 ± 0.57 | 11.82 ± 2.53 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.82 ± 0.00 | 6.09 ± 0.88 | 25.00 ± 2.89 | 1.5 |
| 1.6 ± 0.0 | 97.6 ± 0.2 | 1.23 ± 0.01 | 9.90 ± 2.15 | 42.12 ± 2.21 | 2.6 |
| 1.9 ± 0.0 | 93.1 ± 0.6 | 1.45 ± 0.14 | 10.82 ± 0.66 | 49.29 ± 2.71 | 3.2 |
| 2.2 ± 0.0 | 82.1 ± 0.4 | 1.84 ± 0.08 | 11.75 ± 0.79 | 56.39 ± 4.25 | 3.9 |
| 2.6 ± 0.0 | 64.2 ± 0.6 | 2.23 ± 0.04 | 7.90 ± 0.69 | 52.52 ± 8.22 | 4.6 |
| 3.0 ± 0.0 | 36.5 ± 0.3 | 2.63 ± 0.02 | 5.06 ± 0.02 | 35.44 ± 3.10 | 5.2 |
| 3.2 ± 0.0 | 19.4 ± 0.2 | 2.70 ± 0.03 | 4.98 ± 0.01 | 20.51 ± 0.42 | 5.4 |
| 3.3 ± 0.0 | 8.2 ± 0.0 | 2.75 ± 0.06 | 4.94 ± 0.01 | 12.89 ± 1.70 | 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.78 ± 0.01 | 1.39 ± 0.16 | 2.62 ± 0.34 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.79 ± 0.00 | 2.26 ± 0.26 | 6.21 ± 0.41 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.81 ± 0.00 | 3.46 ± 0.49 | 12.37 ± 1.42 | 1.4 |
| 1.6 ± 0.0 | 99.7 ± 0.0 | 1.05 ± 0.02 | 5.08 ± 0.68 | 21.67 ± 2.27 | 2.2 |
| 2.0 ± 0.0 | 98.4 ± 0.1 | 1.22 ± 0.02 | 6.75 ± 0.66 | 26.58 ± 1.73 | 2.7 |
| 2.5 ± 0.0 | 92.8 ± 0.5 | 1.55 ± 0.01 | 8.69 ± 0.70 | 37.38 ± 2.05 | 3.6 |
| 3.1 ± 0.0 | 75.0 ± 0.3 | 2.11 ± 0.02 | 9.42 ± 1.43 | 38.98 ± 3.25 | 4.7 |
| 3.5 ± 0.0 | 42.6 ± 0.3 | 2.55 ± 0.03 | 8.71 ± 0.63 | 40.67 ± 3.40 | 5.4 |
| 3.7 ± 0.0 | 22.5 ± 0.1 | 2.63 ± 0.03 | 7.82 ± 0.97 | 39.52 ± 3.72 | 5.5 |
| 3.9 ± 0.0 | 9.6 ± 0.1 | 2.63 ± 0.02 | 6.86 ± 0.65 | 40.76 ± 4.45 | 5.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 | 0.77 ± 0.01 | 1.11 ± 0.10 | 1.73 ± 0.44 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.79 ± 0.00 | 1.45 ± 0.10 | 3.16 ± 0.57 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.81 ± 0.00 | 2.13 ± 0.23 | 5.65 ± 0.30 | 1.4 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 1.02 ± 0.01 | 2.99 ± 0.13 | 9.61 ± 1.33 | 1.9 |
| 2.0 ± 0.0 | 99.8 ± 0.1 | 1.07 ± 0.01 | 3.58 ± 0.15 | 11.09 ± 0.64 | 2.3 |
| 2.7 ± 0.0 | 98.8 ± 0.1 | 1.26 ± 0.02 | 4.72 ± 0.24 | 16.48 ± 0.99 | 2.9 |
| 3.8 ± 0.0 | 92.0 ± 0.4 | 1.68 ± 0.04 | 6.23 ± 0.41 | 20.89 ± 1.61 | 4.1 |
| 5.2 ± 0.0 | 63.7 ± 0.2 | 2.27 ± 0.01 | 7.29 ± 0.67 | 27.66 ± 1.27 | 5.4 |
| 6.0 ± 0.0 | 36.8 ± 0.1 | 2.55 ± 0.01 | 7.58 ± 0.22 | 31.92 ± 0.93 | 5.9 |
| 6.6 ± 0.0 | 16.1 ± 0.1 | 2.71 ± 0.02 | 7.34 ± 0.10 | 33.23 ± 2.28 | 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.76 ± 0.01 | 1.02 ± 0.03 | 1.21 ± 0.07 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.24 ± 0.06 | 1.94 ± 0.06 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.81 ± 0.00 | 1.60 ± 0.06 | 3.37 ± 0.27 | 1.4 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 1.01 ± 0.01 | 2.33 ± 0.08 | 5.35 ± 0.25 | 1.9 |
| 2.0 ± 0.0 | 99.9 ± 0.0 | 1.05 ± 0.00 | 2.62 ± 0.08 | 6.64 ± 0.61 | 2.2 |
| 2.7 ± 0.0 | 99.3 ± 0.1 | 1.15 ± 0.01 | 3.35 ± 0.14 | 8.98 ± 0.81 | 2.7 |
| 3.9 ± 0.0 | 94.6 ± 0.1 | 1.52 ± 0.01 | 4.15 ± 0.22 | 12.01 ± 1.12 | 3.8 |
| 5.6 ± 0.0 | 68.7 ± 0.2 | 2.04 ± 0.02 | 5.14 ± 0.12 | 16.06 ± 0.65 | 5.2 |
| 6.4 ± 0.0 | 39.1 ± 0.1 | 2.29 ± 0.01 | 5.32 ± 0.21 | 18.25 ± 0.94 | 5.8 |
| 6.9 ± 0.0 | 16.7 ± 0.1 | 2.42 ± 0.02 | 5.63 ± 0.26 | 18.98 ± 0.92 | 6.0 |
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.74 ± 0.01 | 0.98 ± 0.05 | 1.18 ± 0.11 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.77 ± 0.00 | 1.13 ± 0.03 | 1.49 ± 0.13 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.00 | 1.40 ± 0.05 | 2.19 ± 0.14 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 1.00 ± 0.00 | 1.88 ± 0.03 | 3.16 ± 0.13 | 1.8 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 1.04 ± 0.00 | 2.16 ± 0.05 | 4.13 ± 0.08 | 2.1 |
| 2.7 ± 0.0 | 99.5 ± 0.1 | 1.11 ± 0.01 | 2.70 ± 0.09 | 5.21 ± 0.41 | 2.6 |
| 3.9 ± 0.0 | 95.5 ± 0.3 | 1.39 ± 0.01 | 3.32 ± 0.04 | 6.98 ± 0.30 | 3.7 |
| 5.7 ± 0.0 | 70.2 ± 0.4 | 1.91 ± 0.01 | 3.79 ± 0.03 | 9.51 ± 0.37 | 5.1 |
| 6.5 ± 0.0 | 39.6 ± 0.1 | 2.16 ± 0.01 | 3.90 ± 0.05 | 10.45 ± 0.34 | 5.7 |
| 6.9 ± 0.0 | 16.9 ± 0.1 | 2.30 ± 0.01 | 4.05 ± 0.07 | 10.88 ± 0.23 | 6.0 |
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.67 ± 0.02 | 0.88 ± 0.02 | 1.03 ± 0.02 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.74 ± 0.00 | 1.07 ± 0.01 | 1.27 ± 0.04 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.26 ± 0.03 | 1.60 ± 0.04 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.95 ± 0.02 | 1.63 ± 0.01 | 2.30 ± 0.06 | 1.8 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 1.02 ± 0.01 | 1.87 ± 0.04 | 2.63 ± 0.09 | 2.0 |
| 2.7 ± 0.0 | 99.5 ± 0.1 | 1.09 ± 0.00 | 2.33 ± 0.05 | 3.14 ± 0.06 | 2.6 |
| 3.9 ± 0.0 | 95.6 ± 0.0 | 1.33 ± 0.01 | 2.96 ± 0.02 | 3.78 ± 0.08 | 3.6 |
| 5.8 ± 0.0 | 70.8 ± 0.2 | 1.83 ± 0.01 | 3.34 ± 0.02 | 5.11 ± 0.24 | 5.0 |
| 6.5 ± 0.0 | 39.9 ± 0.2 | 2.09 ± 0.01 | 3.44 ± 0.01 | 5.67 ± 0.13 | 5.7 |
| 7.0 ± 0.0 | 17.0 ± 0.1 | 2.19 ± 0.02 | 3.47 ± 0.02 | 5.95 ± 0.05 | 5.9 |
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
