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.00 | 1.05 ± 0.13 | 1.32 ± 0.07 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.29 ± 0.01 | 1.81 ± 0.10 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.00 | 1.79 ± 0.03 | 2.65 ± 0.17 | 1.4 |
| 1.6 ± 0.0 | 97.9 ± 0.3 | 1.17 ± 0.00 | 3.54 ± 0.06 | 4.64 ± 0.09 | 2.4 |
| 1.9 ± 0.0 | 93.4 ± 0.3 | 1.29 ± 0.02 | 4.15 ± 0.04 | 4.96 ± 0.04 | 3.1 |
| 2.3 ± 0.0 | 83.3 ± 0.5 | 1.70 ± 0.01 | 4.52 ± 0.04 | 5.04 ± 0.01 | 3.7 |
| 2.6 ± 0.0 | 64.4 ± 0.2 | 2.15 ± 0.02 | 4.80 ± 0.03 | 5.10 ± 0.01 | 4.5 |
| 3.0 ± 0.0 | 36.7 ± 0.2 | 2.57 ± 0.01 | 4.86 ± 0.02 | 5.09 ± 0.02 | 5.1 |
| 3.2 ± 0.0 | 19.5 ± 0.2 | 2.64 ± 0.02 | 4.87 ± 0.01 | 5.09 ± 0.01 | 5.3 |
| 3.4 ± 0.0 | 8.2 ± 0.0 | 2.69 ± 0.04 | 4.87 ± 0.01 | 5.07 ± 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.77 ± 0.01 | 1.03 ± 0.08 | 1.26 ± 0.07 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.21 ± 0.01 | 1.49 ± 0.06 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.00 | 1.47 ± 0.04 | 1.94 ± 0.09 | 1.4 |
| 1.6 ± 0.0 | 99.7 ± 0.2 | 1.01 ± 0.01 | 2.38 ± 0.03 | 3.48 ± 0.10 | 2.1 |
| 2.0 ± 0.0 | 98.7 ± 0.2 | 1.12 ± 0.01 | 2.94 ± 0.05 | 4.02 ± 0.06 | 2.5 |
| 2.5 ± 0.0 | 93.0 ± 0.6 | 1.46 ± 0.02 | 3.71 ± 0.05 | 4.39 ± 0.07 | 3.5 |
| 3.1 ± 0.0 | 75.0 ± 0.3 | 1.96 ± 0.02 | 4.18 ± 0.03 | 4.62 ± 0.02 | 4.5 |
| 3.5 ± 0.0 | 42.6 ± 0.2 | 2.40 ± 0.01 | 4.42 ± 0.01 | 4.76 ± 0.01 | 5.3 |
| 3.7 ± 0.0 | 22.7 ± 0.1 | 2.46 ± 0.02 | 4.50 ± 0.00 | 4.81 ± 0.01 | 5.4 |
| 3.9 ± 0.0 | 9.5 ± 0.1 | 2.50 ± 0.02 | 4.57 ± 0.01 | 4.87 ± 0.02 | 5.4 |
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 | 0.96 ± 0.05 | 1.19 ± 0.05 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.12 ± 0.01 | 1.34 ± 0.04 | 1.2 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.00 | 1.32 ± 0.03 | 1.71 ± 0.07 | 1.3 |
| 1.7 ± 0.0 | 100.0 ± 0.0 | 0.99 ± 0.01 | 1.84 ± 0.03 | 2.54 ± 0.05 | 1.9 |
| 2.0 ± 0.0 | 99.8 ± 0.1 | 1.04 ± 0.00 | 2.10 ± 0.03 | 2.93 ± 0.11 | 2.2 |
| 2.7 ± 0.0 | 98.9 ± 0.1 | 1.17 ± 0.02 | 2.66 ± 0.05 | 3.55 ± 0.02 | 2.9 |
| 3.8 ± 0.0 | 91.9 ± 0.3 | 1.55 ± 0.02 | 3.40 ± 0.04 | 3.94 ± 0.04 | 4.0 |
| 5.3 ± 0.0 | 64.0 ± 0.3 | 2.12 ± 0.01 | 3.83 ± 0.02 | 4.14 ± 0.02 | 5.3 |
| 6.0 ± 0.0 | 36.8 ± 0.1 | 2.42 ± 0.01 | 3.97 ± 0.01 | 4.25 ± 0.01 | 5.8 |
| 6.6 ± 0.0 | 16.1 ± 0.1 | 2.59 ± 0.02 | 4.08 ± 0.01 | 4.32 ± 0.01 | 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.75 ± 0.01 | 0.96 ± 0.05 | 1.13 ± 0.04 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.09 ± 0.02 | 1.30 ± 0.05 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.80 ± 0.00 | 1.26 ± 0.04 | 1.55 ± 0.08 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.97 ± 0.01 | 1.64 ± 0.03 | 2.19 ± 0.06 | 1.8 |
| 2.0 ± 0.0 | 99.9 ± 0.1 | 1.03 ± 0.00 | 1.86 ± 0.02 | 2.53 ± 0.02 | 2.1 |
| 2.7 ± 0.0 | 99.4 ± 0.0 | 1.10 ± 0.01 | 2.32 ± 0.03 | 3.12 ± 0.07 | 2.7 |
| 3.9 ± 0.0 | 94.9 ± 0.2 | 1.40 ± 0.01 | 3.05 ± 0.02 | 3.59 ± 0.01 | 3.8 |
| 5.6 ± 0.0 | 68.7 ± 0.1 | 1.91 ± 0.02 | 3.47 ± 0.01 | 3.80 ± 0.01 | 5.1 |
| 6.4 ± 0.0 | 39.0 ± 0.2 | 2.15 ± 0.01 | 3.58 ± 0.01 | 3.87 ± 0.01 | 5.7 |
| 6.9 ± 0.0 | 16.7 ± 0.0 | 2.29 ± 0.01 | 3.62 ± 0.01 | 3.88 ± 0.01 | 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.00 | 0.94 ± 0.02 | 1.10 ± 0.03 | 1.1 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.77 ± 0.00 | 1.08 ± 0.02 | 1.30 ± 0.05 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.79 ± 0.00 | 1.21 ± 0.03 | 1.53 ± 0.07 | 1.3 |
| 1.7 ± 0.0 | 100.0 ± 0.0 | 0.96 ± 0.01 | 1.58 ± 0.03 | 2.09 ± 0.03 | 1.8 |
| 2.0 ± 0.0 | 99.9 ± 0.0 | 1.02 ± 0.00 | 1.80 ± 0.06 | 2.40 ± 0.07 | 2.1 |
| 2.7 ± 0.0 | 99.4 ± 0.1 | 1.09 ± 0.01 | 2.20 ± 0.03 | 2.99 ± 0.03 | 2.6 |
| 3.9 ± 0.0 | 95.4 ± 0.3 | 1.33 ± 0.01 | 2.86 ± 0.02 | 3.37 ± 0.02 | 3.6 |
| 5.8 ± 0.0 | 69.9 ± 0.1 | 1.83 ± 0.01 | 3.30 ± 0.01 | 3.60 ± 0.01 | 5.1 |
| 6.5 ± 0.0 | 39.5 ± 0.1 | 2.08 ± 0.01 | 3.37 ± 0.01 | 3.63 ± 0.01 | 5.7 |
| 6.9 ± 0.0 | 16.9 ± 0.1 | 2.16 ± 0.01 | 3.40 ± 0.01 | 3.66 ± 0.01 | 5.9 |
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.66 ± 0.02 | 0.89 ± 0.01 | 1.08 ± 0.04 | 1.0 |
| 0.4 ± 0.0 | 100.0 ± 0.0 | 0.74 ± 0.01 | 1.05 ± 0.01 | 1.17 ± 0.03 | 1.1 |
| 0.8 ± 0.0 | 100.0 ± 0.0 | 0.78 ± 0.00 | 1.18 ± 0.02 | 1.44 ± 0.03 | 1.3 |
| 1.6 ± 0.0 | 100.0 ± 0.0 | 0.91 ± 0.02 | 1.53 ± 0.03 | 1.94 ± 0.06 | 1.8 |
| 2.1 ± 0.0 | 99.9 ± 0.0 | 1.01 ± 0.01 | 1.71 ± 0.03 | 2.30 ± 0.08 | 2.0 |
| 2.7 ± 0.0 | 99.5 ± 0.1 | 1.07 ± 0.00 | 2.12 ± 0.05 | 2.85 ± 0.09 | 2.6 |
| 3.9 ± 0.0 | 95.6 ± 0.2 | 1.30 ± 0.01 | 2.79 ± 0.02 | 3.28 ± 0.02 | 3.6 |
| 5.8 ± 0.0 | 70.7 ± 0.2 | 1.78 ± 0.01 | 3.20 ± 0.01 | 3.44 ± 0.01 | 5.0 |
| 6.6 ± 0.0 | 40.0 ± 0.1 | 2.02 ± 0.01 | 3.26 ± 0.01 | 3.47 ± 0.01 | 5.7 |
| 7.0 ± 0.0 | 17.0 ± 0.1 | 2.11 ± 0.01 | 3.27 ± 0.01 | 3.48 ± 0.00 | 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
