Prepared transactions are bottlenecked on secondaries

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Replication
    • ALL
    • Repl 2025-03-17, Repl 2025-03-31, Repl 2025-04-28, Repl 2025-05-12, Repl 2025-05-26, Repl 2025-06-09
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Despite improvements in 7.0 and 8.0 (SERVER-75800) to batch transaction prepare and commit oplog entries on secondaries, we still do not batch prepares and commits together. We also cannot group commits with other CRUD ops. Under high load, this quickly creates a bottleneck on secondary batch application which significantly increases cross-shard transaction latencies.

            Assignee:
            Unassigned
            Reporter:
            Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            18 Start watching this issue

              Created:
              Updated: