Commit Overhead vs Throughput

Commit Overhead vs Throughput

Analysis of commit protocol overhead as percentage of total transaction time.

Overhead = (commit_latency / total_latency) × 100

This represents time spent in retries, exponential backoff, and manifest I/O.

Values shown as mean ± standard deviation across seeds.

real_conflict_probability = 0.0

Throughput (c/s)Success Rate (%)Mean Overhead (%)P50 Overhead (%)P95 Overhead (%)P99 Overhead (%)
0.2 ± 0.0100.0 ± 0.00.4 ± 0.00.4 ± 0.00.6 ± 0.00.7 ± 0.0
0.5 ± 0.0100.0 ± 0.00.8 ± 0.00.8 ± 0.01.0 ± 0.01.2 ± 0.0
1.0 ± 0.0100.0 ± 0.01.5 ± 0.01.5 ± 0.01.8 ± 0.02.0 ± 0.1
2.0 ± 0.0100.0 ± 0.02.9 ± 0.02.8 ± 0.03.3 ± 0.13.6 ± 0.1
4.9 ± 0.0100.0 ± 0.07.0 ± 0.16.9 ± 0.17.5 ± 0.17.9 ± 0.1
9.7 ± 0.198.8 ± 0.113.6 ± 0.113.6 ± 0.114.4 ± 0.214.8 ± 0.1
15.1 ± 0.076.2 ± 0.321.1 ± 0.121.1 ± 0.121.6 ± 0.021.9 ± 0.0
17.6 ± 0.035.0 ± 0.024.5 ± 0.024.5 ± 0.024.9 ± 0.025.1 ± 0.0
18.6 ± 0.018.1 ± 0.025.9 ± 0.025.9 ± 0.026.3 ± 0.026.4 ± 0.0

real_conflict_probability = 0.1

Throughput (c/s)Success Rate (%)Mean Overhead (%)P50 Overhead (%)P95 Overhead (%)P99 Overhead (%)
0.2 ± 0.0100.0 ± 0.00.4 ± 0.00.4 ± 0.00.7 ± 0.11.1 ± 0.2
0.5 ± 0.0100.0 ± 0.00.9 ± 0.00.8 ± 0.01.2 ± 0.01.7 ± 0.1
1.0 ± 0.0100.0 ± 0.01.6 ± 0.01.5 ± 0.02.0 ± 0.02.5 ± 0.1
2.0 ± 0.0100.0 ± 0.02.9 ± 0.12.9 ± 0.03.5 ± 0.14.0 ± 0.1
5.0 ± 0.1100.0 ± 0.07.1 ± 0.17.0 ± 0.17.9 ± 0.18.5 ± 0.2
9.6 ± 0.197.7 ± 0.113.6 ± 0.113.6 ± 0.114.6 ± 0.115.2 ± 0.1
14.5 ± 0.073.6 ± 0.420.4 ± 0.020.3 ± 0.021.2 ± 0.021.8 ± 0.0
17.2 ± 0.034.2 ± 0.124.1 ± 0.024.0 ± 0.024.8 ± 0.025.3 ± 0.0
18.3 ± 0.017.8 ± 0.125.6 ± 0.025.5 ± 0.026.3 ± 0.026.7 ± 0.0

real_conflict_probability = 0.3

Throughput (c/s)Success Rate (%)Mean Overhead (%)P50 Overhead (%)P95 Overhead (%)P99 Overhead (%)
0.2 ± 0.0100.0 ± 0.00.5 ± 0.00.4 ± 0.01.0 ± 0.11.3 ± 0.2
0.5 ± 0.0100.0 ± 0.00.9 ± 0.00.8 ± 0.01.5 ± 0.02.1 ± 0.1
1.0 ± 0.0100.0 ± 0.01.7 ± 0.01.6 ± 0.02.4 ± 0.13.1 ± 0.1
2.0 ± 0.0100.0 ± 0.03.1 ± 0.02.9 ± 0.03.9 ± 0.04.7 ± 0.1
4.9 ± 0.199.7 ± 0.17.3 ± 0.17.1 ± 0.18.4 ± 0.19.4 ± 0.1
9.2 ± 0.193.6 ± 0.213.4 ± 0.113.2 ± 0.114.7 ± 0.115.6 ± 0.1
13.3 ± 0.067.0 ± 0.319.1 ± 0.018.9 ± 0.120.3 ± 0.121.1 ± 0.1
16.1 ± 0.032.0 ± 0.122.8 ± 0.022.7 ± 0.023.9 ± 0.024.6 ± 0.0
17.4 ± 0.016.9 ± 0.024.7 ± 0.024.6 ± 0.025.8 ± 0.026.4 ± 0.0

real_conflict_probability = 0.5

Throughput (c/s)Success Rate (%)Mean Overhead (%)P50 Overhead (%)P95 Overhead (%)P99 Overhead (%)
0.2 ± 0.0100.0 ± 0.00.5 ± 0.00.4 ± 0.01.1 ± 0.11.6 ± 0.2
0.5 ± 0.0100.0 ± 0.01.0 ± 0.00.9 ± 0.01.7 ± 0.12.3 ± 0.2
1.0 ± 0.0100.0 ± 0.01.7 ± 0.01.6 ± 0.02.6 ± 0.03.3 ± 0.1
2.0 ± 0.0100.0 ± 0.03.3 ± 0.03.1 ± 0.04.4 ± 0.15.3 ± 0.1
4.9 ± 0.098.2 ± 0.27.5 ± 0.07.2 ± 0.09.1 ± 0.110.3 ± 0.1
8.5 ± 0.086.2 ± 0.312.7 ± 0.112.4 ± 0.114.4 ± 0.115.6 ± 0.1
12.0 ± 0.060.4 ± 0.317.6 ± 0.017.3 ± 0.019.2 ± 0.020.1 ± 0.1
14.6 ± 0.029.1 ± 0.121.1 ± 0.021.0 ± 0.022.6 ± 0.023.5 ± 0.0
16.1 ± 0.015.7 ± 0.023.2 ± 0.023.0 ± 0.024.6 ± 0.025.4 ± 0.0

Interpretation

  • Low overhead (<10%): System operating efficiently, minimal contention
  • Medium overhead (10-30%): Moderate contention, acceptable performance
  • High overhead (30-50%): High contention, commit protocol becoming significant
  • Very high overhead (>50%): Commit protocol dominates, system saturated

Values shown as mean ± standard deviation across multiple seeds. At saturation, overhead can exceed 50%, meaning more time is spent retrying commits than executing transactions!