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.3 ± 0.00.3 ± 0.00.5 ± 0.00.6 ± 0.1
0.5 ± 0.0100.0 ± 0.00.7 ± 0.00.7 ± 0.01.0 ± 0.01.1 ± 0.1
1.0 ± 0.0100.0 ± 0.01.4 ± 0.01.4 ± 0.01.7 ± 0.01.9 ± 0.1
1.9 ± 0.0100.0 ± 0.02.8 ± 0.02.7 ± 0.03.1 ± 0.13.4 ± 0.1
4.9 ± 0.1100.0 ± 0.06.9 ± 0.16.9 ± 0.17.4 ± 0.27.7 ± 0.2
9.9 ± 0.1100.0 ± 0.013.7 ± 0.113.7 ± 0.114.4 ± 0.214.8 ± 0.2
19.7 ± 0.1100.0 ± 0.027.2 ± 0.127.2 ± 0.228.2 ± 0.128.6 ± 0.2
33.4 ± 0.067.8 ± 0.146.3 ± 0.046.2 ± 0.046.6 ± 0.046.8 ± 0.0
36.4 ± 0.036.1 ± 0.050.3 ± 0.050.2 ± 0.050.5 ± 0.050.6 ± 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.3 ± 0.00.3 ± 0.00.6 ± 0.00.9 ± 0.2
0.5 ± 0.0100.0 ± 0.00.7 ± 0.00.7 ± 0.01.1 ± 0.11.4 ± 0.1
1.0 ± 0.0100.0 ± 0.01.5 ± 0.01.4 ± 0.01.9 ± 0.02.2 ± 0.1
2.0 ± 0.0100.0 ± 0.02.8 ± 0.02.8 ± 0.03.3 ± 0.03.7 ± 0.0
4.9 ± 0.1100.0 ± 0.06.9 ± 0.16.9 ± 0.17.6 ± 0.18.0 ± 0.1
9.9 ± 0.1100.0 ± 0.013.8 ± 0.213.8 ± 0.214.6 ± 0.115.2 ± 0.1
19.7 ± 0.199.9 ± 0.027.4 ± 0.127.4 ± 0.128.3 ± 0.228.9 ± 0.2
32.7 ± 0.166.0 ± 0.145.4 ± 0.045.3 ± 0.046.0 ± 0.046.3 ± 0.0
35.6 ± 0.035.3 ± 0.149.4 ± 0.049.4 ± 0.050.0 ± 0.050.3 ± 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.3 ± 0.00.3 ± 0.00.8 ± 0.01.2 ± 0.1
0.5 ± 0.0100.0 ± 0.00.8 ± 0.00.8 ± 0.01.4 ± 0.01.7 ± 0.1
1.0 ± 0.0100.0 ± 0.01.5 ± 0.01.5 ± 0.02.1 ± 0.12.5 ± 0.1
2.0 ± 0.0100.0 ± 0.02.9 ± 0.02.8 ± 0.03.5 ± 0.04.0 ± 0.1
4.9 ± 0.0100.0 ± 0.07.1 ± 0.17.0 ± 0.17.9 ± 0.18.5 ± 0.1
9.8 ± 0.1100.0 ± 0.013.9 ± 0.113.8 ± 0.114.9 ± 0.115.6 ± 0.1
19.6 ± 0.199.5 ± 0.027.5 ± 0.127.4 ± 0.128.6 ± 0.129.4 ± 0.1
31.1 ± 0.062.6 ± 0.143.4 ± 0.043.3 ± 0.044.3 ± 0.044.9 ± 0.0
34.0 ± 0.033.6 ± 0.047.6 ± 0.047.5 ± 0.048.4 ± 0.048.8 ± 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.4 ± 0.00.3 ± 0.01.0 ± 0.11.3 ± 0.1
0.5 ± 0.0100.0 ± 0.00.8 ± 0.00.8 ± 0.01.5 ± 0.11.8 ± 0.1
1.0 ± 0.0100.0 ± 0.01.6 ± 0.01.5 ± 0.02.3 ± 0.12.7 ± 0.1
2.0 ± 0.0100.0 ± 0.03.0 ± 0.12.9 ± 0.13.7 ± 0.14.2 ± 0.1
4.9 ± 0.0100.0 ± 0.07.2 ± 0.17.1 ± 0.18.2 ± 0.18.8 ± 0.1
9.9 ± 0.1100.0 ± 0.014.1 ± 0.114.0 ± 0.115.3 ± 0.116.1 ± 0.1
19.4 ± 0.198.5 ± 0.027.5 ± 0.127.4 ± 0.129.0 ± 0.229.9 ± 0.2
29.2 ± 0.059.0 ± 0.141.1 ± 0.041.0 ± 0.042.3 ± 0.043.0 ± 0.0
32.2 ± 0.031.7 ± 0.145.3 ± 0.045.2 ± 0.046.4 ± 0.046.9 ± 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!