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.8 ± 0.00.8 ± 0.01.1 ± 0.01.2 ± 0.1
1.0 ± 0.0100.0 ± 0.01.5 ± 0.01.4 ± 0.01.8 ± 0.12.0 ± 0.1
2.0 ± 0.0100.0 ± 0.02.8 ± 0.02.8 ± 0.03.3 ± 0.13.5 ± 0.1
5.0 ± 0.0100.0 ± 0.07.0 ± 0.17.0 ± 0.17.7 ± 0.18.1 ± 0.1
9.5 ± 0.196.8 ± 0.213.4 ± 0.113.4 ± 0.114.1 ± 0.114.5 ± 0.1
13.7 ± 0.069.2 ± 0.119.3 ± 0.019.3 ± 0.019.9 ± 0.020.3 ± 0.1
16.0 ± 0.031.8 ± 0.022.5 ± 0.022.5 ± 0.023.0 ± 0.023.3 ± 0.0
16.9 ± 0.016.5 ± 0.123.9 ± 0.023.8 ± 0.024.3 ± 0.024.5 ± 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.3 ± 0.00.7 ± 0.11.0 ± 0.1
0.5 ± 0.0100.0 ± 0.00.8 ± 0.00.8 ± 0.01.2 ± 0.01.5 ± 0.1
1.0 ± 0.0100.0 ± 0.01.5 ± 0.01.5 ± 0.01.9 ± 0.02.4 ± 0.1
2.0 ± 0.1100.0 ± 0.02.9 ± 0.12.8 ± 0.13.4 ± 0.13.8 ± 0.1
4.9 ± 0.099.9 ± 0.07.1 ± 0.17.0 ± 0.17.8 ± 0.18.4 ± 0.1
9.5 ± 0.095.8 ± 0.113.4 ± 0.113.4 ± 0.114.3 ± 0.115.0 ± 0.1
13.4 ± 0.067.4 ± 0.318.9 ± 0.118.9 ± 0.119.8 ± 0.020.4 ± 0.1
15.6 ± 0.031.2 ± 0.122.2 ± 0.022.1 ± 0.022.9 ± 0.023.4 ± 0.0
16.7 ± 0.016.2 ± 0.123.6 ± 0.023.5 ± 0.024.3 ± 0.024.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.4 ± 0.00.3 ± 0.00.9 ± 0.11.2 ± 0.1
0.5 ± 0.0100.0 ± 0.00.9 ± 0.00.8 ± 0.01.5 ± 0.01.8 ± 0.1
1.0 ± 0.0100.0 ± 0.01.6 ± 0.01.5 ± 0.02.2 ± 0.02.6 ± 0.1
2.0 ± 0.0100.0 ± 0.03.0 ± 0.02.9 ± 0.03.7 ± 0.14.3 ± 0.1
4.9 ± 0.199.9 ± 0.07.2 ± 0.17.1 ± 0.18.1 ± 0.18.9 ± 0.1
9.2 ± 0.093.6 ± 0.113.3 ± 0.013.2 ± 0.014.5 ± 0.015.4 ± 0.1
12.6 ± 0.064.0 ± 0.218.1 ± 0.018.0 ± 0.019.3 ± 0.020.1 ± 0.1
14.9 ± 0.029.8 ± 0.121.4 ± 0.021.3 ± 0.022.4 ± 0.023.0 ± 0.0
16.1 ± 0.015.6 ± 0.023.0 ± 0.022.9 ± 0.023.9 ± 0.024.5 ± 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.4 ± 0.01.0 ± 0.11.3 ± 0.1
0.5 ± 0.0100.0 ± 0.00.9 ± 0.00.9 ± 0.01.5 ± 0.11.9 ± 0.1
1.0 ± 0.0100.0 ± 0.01.7 ± 0.01.6 ± 0.02.3 ± 0.12.8 ± 0.1
2.0 ± 0.0100.0 ± 0.03.1 ± 0.03.0 ± 0.03.9 ± 0.14.5 ± 0.1
4.9 ± 0.099.8 ± 0.17.4 ± 0.07.2 ± 0.08.5 ± 0.09.4 ± 0.1
8.9 ± 0.090.5 ± 0.113.1 ± 0.012.9 ± 0.014.5 ± 0.015.6 ± 0.0
11.8 ± 0.060.1 ± 0.217.3 ± 0.017.1 ± 0.018.7 ± 0.019.6 ± 0.0
14.0 ± 0.028.0 ± 0.120.4 ± 0.020.3 ± 0.021.7 ± 0.022.4 ± 0.0
15.3 ± 0.014.9 ± 0.022.2 ± 0.022.1 ± 0.023.3 ± 0.023.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!