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.45 ± 0.00 | 1.50 ± 0.78 | 4.07 ± 1.41 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.00 | 2.82 ± 0.88 | 10.43 ± 1.17 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 5.05 ± 0.94 | 21.66 ± 1.62 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.52 ± 0.01 | 9.46 ± 1.76 | 47.83 ± 4.29 | 1.8 |
| 2.1 ± 0.0 | 99.8 ± 0.1 | 0.60 ± 0.01 | 12.47 ± 1.23 | 58.51 ± 5.61 | 2.1 |
| 2.7 ± 0.0 | 98.4 ± 0.1 | 0.70 ± 0.01 | 15.03 ± 0.47 | 74.32 ± 5.09 | 2.7 |
| 3.6 ± 0.0 | 87.7 ± 0.4 | 1.01 ± 0.02 | 15.28 ± 2.31 | 88.98 ± 4.90 | 3.9 |
| 4.3 ± 0.0 | 53.0 ± 0.3 | 1.32 ± 0.02 | 6.01 ± 1.82 | 72.12 ± 10.65 | 4.9 |
| 4.8 ± 0.0 | 29.4 ± 0.1 | 1.41 ± 0.02 | 2.73 ± 0.01 | 45.89 ± 4.60 | 5.2 |
| 5.3 ± 0.0 | 13.0 ± 0.1 | 1.44 ± 0.02 | 2.64 ± 0.01 | 22.38 ± 4.51 | 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.45 ± 0.01 | 0.91 ± 0.22 | 2.53 ± 1.03 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.01 | 1.58 ± 0.26 | 6.79 ± 1.55 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.46 ± 0.01 | 2.71 ± 0.51 | 11.82 ± 0.89 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.48 ± 0.00 | 5.10 ± 0.63 | 21.18 ± 2.12 | 1.6 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.49 ± 0.00 | 6.69 ± 0.95 | 28.94 ± 1.83 | 1.7 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.53 ± 0.00 | 8.16 ± 0.62 | 37.81 ± 2.06 | 2.1 |
| 4.1 ± 0.0 | 99.4 ± 0.1 | 0.67 ± 0.00 | 11.04 ± 1.27 | 54.79 ± 2.46 | 2.8 |
| 6.7 ± 0.0 | 81.5 ± 0.4 | 1.13 ± 0.01 | 13.20 ± 0.88 | 76.58 ± 7.38 | 5.1 |
| 7.6 ± 0.0 | 46.5 ± 0.2 | 1.34 ± 0.01 | 6.60 ± 0.41 | 65.56 ± 3.36 | 5.9 |
| 8.3 ± 0.0 | 20.3 ± 0.1 | 1.37 ± 0.01 | 2.63 ± 0.04 | 55.81 ± 4.75 | 6.0 |
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.44 ± 0.00 | 0.65 ± 0.04 | 1.30 ± 0.18 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.00 | 0.81 ± 0.08 | 2.44 ± 0.37 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.46 ± 0.00 | 1.24 ± 0.11 | 4.48 ± 0.48 | 1.2 |
| 1.7 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 2.36 ± 0.27 | 9.42 ± 0.54 | 1.5 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.48 ± 0.00 | 2.75 ± 0.28 | 11.74 ± 1.16 | 1.6 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.49 ± 0.00 | 3.43 ± 0.13 | 15.06 ± 0.91 | 1.8 |
| 4.1 ± 0.0 | 100.0 ± 0.0 | 0.52 ± 0.00 | 5.45 ± 0.29 | 23.86 ± 2.46 | 2.1 |
| 8.1 ± 0.0 | 99.2 ± 0.1 | 0.66 ± 0.00 | 9.31 ± 0.58 | 43.04 ± 2.12 | 3.3 |
| 13.9 ± 0.0 | 85.3 ± 0.1 | 1.00 ± 0.01 | 12.10 ± 0.56 | 65.07 ± 1.31 | 5.1 |
| 17.8 ± 0.0 | 43.4 ± 0.1 | 1.32 ± 0.01 | 6.56 ± 0.44 | 64.90 ± 1.30 | 6.3 |
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.43 ± 0.01 | 0.63 ± 0.03 | 1.01 ± 0.08 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.00 | 0.72 ± 0.05 | 1.55 ± 0.23 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.00 | 0.90 ± 0.08 | 2.79 ± 0.14 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 1.34 ± 0.09 | 4.96 ± 0.43 | 1.4 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 1.62 ± 0.12 | 6.11 ± 0.57 | 1.5 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.48 ± 0.00 | 2.03 ± 0.18 | 7.76 ± 0.34 | 1.7 |
| 4.1 ± 0.0 | 100.0 ± 0.0 | 0.50 ± 0.00 | 3.02 ± 0.16 | 12.03 ± 0.86 | 2.0 |
| 8.2 ± 0.0 | 99.9 ± 0.0 | 0.55 ± 0.00 | 5.24 ± 0.19 | 23.25 ± 0.85 | 2.8 |
| 15.7 ± 0.0 | 95.5 ± 0.2 | 0.72 ± 0.00 | 8.89 ± 0.31 | 42.38 ± 1.91 | 4.2 |
| 24.9 ± 0.1 | 60.9 ± 0.1 | 0.98 ± 0.00 | 9.59 ± 0.27 | 57.17 ± 1.48 | 5.7 |
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.41 ± 0.00 | 0.56 ± 0.03 | 0.68 ± 0.05 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.43 ± 0.00 | 0.60 ± 0.01 | 0.98 ± 0.09 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.45 ± 0.00 | 0.71 ± 0.02 | 1.62 ± 0.11 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.46 ± 0.00 | 0.93 ± 0.07 | 2.65 ± 0.10 | 1.4 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 1.06 ± 0.05 | 3.25 ± 0.28 | 1.5 |
| 2.7 ± 0.0 | 100.0 ± 0.0 | 0.48 ± 0.00 | 1.23 ± 0.15 | 4.11 ± 0.42 | 1.6 |
| 4.1 ± 0.0 | 100.0 ± 0.0 | 0.49 ± 0.00 | 1.55 ± 0.06 | 5.85 ± 0.57 | 1.9 |
| 8.2 ± 0.0 | 100.0 ± 0.0 | 0.53 ± 0.00 | 2.81 ± 0.19 | 11.47 ± 0.37 | 2.6 |
| 16.0 ± 0.0 | 97.3 ± 0.1 | 0.61 ± 0.00 | 4.92 ± 0.13 | 21.52 ± 0.74 | 3.8 |
| 26.9 ± 0.0 | 65.7 ± 0.1 | 0.78 ± 0.00 | 6.81 ± 0.35 | 34.00 ± 1.73 | 5.4 |
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.33 ± 0.01 | 0.54 ± 0.01 | 0.63 ± 0.02 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.41 ± 0.00 | 0.57 ± 0.02 | 0.67 ± 0.03 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.43 ± 0.00 | 0.61 ± 0.01 | 0.92 ± 0.05 | 1.2 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.46 ± 0.00 | 0.68 ± 0.01 | 1.28 ± 0.08 | 1.4 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.46 ± 0.00 | 0.74 ± 0.02 | 1.59 ± 0.12 | 1.5 |
| 2.8 ± 0.0 | 100.0 ± 0.0 | 0.47 ± 0.00 | 0.81 ± 0.03 | 1.98 ± 0.13 | 1.6 |
| 4.1 ± 0.0 | 100.0 ± 0.0 | 0.49 ± 0.00 | 0.94 ± 0.02 | 2.81 ± 0.13 | 1.8 |
| 8.2 ± 0.0 | 100.0 ± 0.0 | 0.52 ± 0.00 | 1.43 ± 0.04 | 4.97 ± 0.26 | 2.4 |
| 16.0 ± 0.0 | 97.9 ± 0.1 | 0.58 ± 0.00 | 2.22 ± 0.09 | 9.03 ± 0.21 | 3.6 |
| 27.6 ± 0.1 | 67.3 ± 0.1 | 0.70 ± 0.00 | 3.45 ± 0.07 | 14.84 ± 0.28 | 5.2 |
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
