[CASSANDRA-13508] Make system.paxos table compaction strategy configurable

• Type: Improvement
• Status: Awaiting Feedback
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Lightweight Transactions, Legacy/Coordination
• Labels: LWT core paxos
• Assignee: Jay Zhuang
• Reporter: Jay Zhuang

Authors

Jay Zhuang

• Created: 09/May/17 01:51
• Updated: 07/Mar/23 10:53

Description

The default compaction strategy for system.paxos table is LCS for performance reason: CASSANDRA-7753. But for CAS heavily used cluster, the system is busy with system.paxos compaction.

As the data in paxos table are TTL'ed, TWCS might be a better fit. In our test, it significantly reduced the number of compaction without impacting the latency too much:

The time window for TWCS is set to 2 minutes for the test.

Here is the p99 latency impact:

the yellow one is LCS, the purple one is TWCS. Average p99 has about 10% increase.

Issue Links

• is related to: CASSANDRA-13548 system.paxos performance improvements for LWT

Sub-Tasks

• Change system.paxos default compaction strategy to TWCS: Resolved