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.68 ± 0.00 | 1.55 ± 0.21 | 6.31 ± 2.55 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.69 ± 0.00 | 3.21 ± 0.59 | 10.93 ± 1.90 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.70 ± 0.00 | 5.70 ± 1.00 | 24.15 ± 4.54 | 1.4 |
| 1.6 ± 0.0 | 99.1 ± 0.2 | 0.88 ± 0.08 | 10.12 ± 1.13 | 42.92 ± 3.11 | 2.2 |
| 2.0 ± 0.0 | 97.0 ± 0.3 | 1.07 ± 0.01 | 11.88 ± 1.19 | 51.29 ± 2.46 | 2.7 |
| 2.5 ± 0.0 | 89.0 ± 0.3 | 1.43 ± 0.02 | 9.84 ± 0.71 | 54.12 ± 5.88 | 3.5 |
| 3.0 ± 0.0 | 72.2 ± 0.3 | 1.81 ± 0.02 | 4.46 ± 0.02 | 44.70 ± 4.60 | 4.2 |
| 3.5 ± 0.0 | 43.0 ± 0.1 | 2.22 ± 0.01 | 4.27 ± 0.01 | 10.17 ± 2.79 | 5.0 |
| 3.8 ± 0.0 | 23.1 ± 0.1 | 2.27 ± 0.01 | 4.24 ± 0.01 | 4.41 ± 0.02 | 5.3 |
| 4.0 ± 0.0 | 9.8 ± 0.1 | 2.31 ± 0.03 | 4.23 ± 0.01 | 4.39 ± 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.68 ± 0.00 | 1.44 ± 0.15 | 5.09 ± 1.78 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.69 ± 0.00 | 3.43 ± 0.31 | 12.09 ± 2.19 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.70 ± 0.01 | 5.11 ± 1.10 | 21.16 ± 3.46 | 1.4 |
| 1.6 ± 0.0 | 99.9 ± 0.0 | 0.84 ± 0.04 | 9.29 ± 1.50 | 44.60 ± 3.09 | 1.9 |
| 2.0 ± 0.0 | 99.5 ± 0.1 | 0.94 ± 0.01 | 12.88 ± 1.17 | 59.03 ± 8.25 | 2.3 |
| 2.6 ± 0.0 | 96.8 ± 0.3 | 1.12 ± 0.02 | 14.03 ± 1.42 | 66.00 ± 7.45 | 3.0 |
| 3.4 ± 0.0 | 83.3 ± 0.2 | 1.54 ± 0.02 | 8.53 ± 1.41 | 67.71 ± 7.68 | 4.1 |
| 4.1 ± 0.0 | 49.8 ± 0.1 | 2.02 ± 0.02 | 3.98 ± 0.02 | 34.28 ± 4.45 | 5.1 |
| 4.3 ± 0.0 | 26.6 ± 0.2 | 2.09 ± 0.04 | 4.00 ± 0.02 | 20.59 ± 5.64 | 5.2 |
| 4.7 ± 0.0 | 11.4 ± 0.0 | 2.13 ± 0.03 | 4.02 ± 0.02 | 5.37 ± 2.25 | 5.3 |
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.68 ± 0.01 | 1.56 ± 0.27 | 4.71 ± 1.63 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.69 ± 0.00 | 2.83 ± 0.88 | 11.84 ± 2.15 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.70 ± 0.00 | 5.90 ± 0.58 | 23.76 ± 2.61 | 1.4 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.84 ± 0.02 | 10.23 ± 1.59 | 46.17 ± 7.25 | 1.8 |
| 2.1 ± 0.0 | 99.9 ± 0.0 | 0.90 ± 0.00 | 12.86 ± 0.43 | 56.83 ± 4.45 | 2.1 |
| 2.7 ± 0.0 | 99.6 ± 0.1 | 0.96 ± 0.00 | 16.57 ± 2.05 | 72.12 ± 3.41 | 2.6 |
| 3.9 ± 0.0 | 96.4 ± 0.3 | 1.28 ± 0.01 | 21.14 ± 1.51 | 101.49 ± 4.58 | 3.6 |
| 6.0 ± 0.0 | 73.1 ± 0.2 | 1.82 ± 0.03 | 14.89 ± 2.38 | 114.41 ± 6.97 | 5.1 |
| 7.1 ± 0.0 | 43.2 ± 0.2 | 2.13 ± 0.01 | 3.64 ± 0.01 | 80.55 ± 7.74 | 5.8 |
| 7.7 ± 0.0 | 18.8 ± 0.0 | 2.28 ± 0.02 | 3.63 ± 0.01 | 36.02 ± 4.22 | 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.67 ± 0.00 | 1.58 ± 0.27 | 5.28 ± 1.17 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.69 ± 0.00 | 2.85 ± 0.57 | 10.98 ± 1.73 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.70 ± 0.00 | 6.10 ± 1.27 | 22.41 ± 2.74 | 1.4 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.04 | 9.97 ± 1.41 | 46.36 ± 5.94 | 1.7 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 0.89 ± 0.00 | 13.39 ± 0.80 | 58.68 ± 3.39 | 2.0 |
| 2.7 ± 0.0 | 99.8 ± 0.0 | 0.94 ± 0.00 | 17.09 ± 1.46 | 76.21 ± 7.51 | 2.4 |
| 4.0 ± 0.0 | 98.0 ± 0.2 | 1.16 ± 0.00 | 23.74 ± 1.36 | 113.75 ± 5.19 | 3.4 |
| 6.4 ± 0.0 | 78.3 ± 0.2 | 1.64 ± 0.01 | 25.34 ± 3.17 | 151.86 ± 10.10 | 5.0 |
| 7.5 ± 0.0 | 46.0 ± 0.2 | 1.99 ± 0.01 | 16.32 ± 1.77 | 155.21 ± 5.20 | 5.8 |
| 7.9 ± 0.0 | 19.4 ± 0.1 | 2.07 ± 0.01 | 14.17 ± 0.54 | 129.89 ± 5.37 | 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.65 ± 0.00 | 1.56 ± 0.46 | 5.29 ± 0.96 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.68 ± 0.00 | 2.79 ± 0.72 | 9.95 ± 1.47 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.70 ± 0.00 | 4.41 ± 1.43 | 21.28 ± 4.00 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.04 | 9.53 ± 1.28 | 45.89 ± 4.09 | 1.7 |
| 2.0 ± 0.0 | 100.0 ± 0.0 | 0.89 ± 0.01 | 12.37 ± 1.02 | 53.95 ± 2.92 | 1.9 |
| 2.7 ± 0.0 | 99.9 ± 0.1 | 0.93 ± 0.00 | 16.44 ± 1.44 | 79.76 ± 5.08 | 2.3 |
| 4.0 ± 0.0 | 98.4 ± 0.1 | 1.12 ± 0.00 | 23.48 ± 1.70 | 113.79 ± 4.03 | 3.2 |
| 6.5 ± 0.0 | 79.9 ± 0.2 | 1.58 ± 0.01 | 28.95 ± 2.38 | 162.00 ± 5.68 | 4.8 |
| 7.7 ± 0.0 | 46.8 ± 0.2 | 1.91 ± 0.01 | 23.75 ± 1.68 | 167.58 ± 7.64 | 5.8 |
| 8.0 ± 0.0 | 19.6 ± 0.0 | 2.03 ± 0.01 | 20.34 ± 0.90 | 163.28 ± 9.53 | 6.1 |
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.58 ± 0.01 | 0.97 ± 0.14 | 5.41 ± 0.54 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.66 ± 0.00 | 2.06 ± 0.63 | 10.02 ± 2.22 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.68 ± 0.00 | 5.57 ± 0.73 | 22.90 ± 2.24 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.75 ± 0.01 | 9.45 ± 0.90 | 42.40 ± 5.46 | 1.7 |
| 2.1 ± 0.0 | 100.0 ± 0.0 | 0.88 ± 0.01 | 12.35 ± 0.89 | 56.04 ± 3.08 | 1.9 |
| 2.7 ± 0.0 | 99.9 ± 0.1 | 0.92 ± 0.00 | 15.26 ± 0.91 | 76.81 ± 3.09 | 2.2 |
| 4.0 ± 0.0 | 98.3 ± 0.2 | 1.09 ± 0.00 | 23.65 ± 3.13 | 111.57 ± 2.70 | 3.1 |
| 6.6 ± 0.0 | 80.2 ± 0.1 | 1.47 ± 0.02 | 32.19 ± 1.17 | 175.48 ± 5.34 | 4.7 |
| 7.7 ± 0.0 | 47.2 ± 0.3 | 1.89 ± 0.00 | 28.41 ± 2.00 | 180.01 ± 8.19 | 5.8 |
| 8.0 ± 0.0 | 19.7 ± 0.1 | 2.00 ± 0.04 | 26.68 ± 1.29 | 177.38 ± 6.94 | 6.1 |
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
