[CASSANDRA-13548] system.paxos performance improvements for LWT

• Type: Improvement
• Status: Open
• Priority: Low
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Lightweight Transactions, Legacy/Core
• Assignee: Unassigned
• Reporter: Jeff Jirsa
• Created: 23/May/17 15:44
• Updated: 07/Mar/23 10:54

Description

There are a few practical changes we can make to system.paxos that will improve (especially read) performance for LWT:

• We should decrease the compression chunk size for situations where we have to go to disk

• We can change the primary key structure so that the row key and CFID are both part of the partition key, which will decrease LCS compaction activity in use cases where a row key is common across tables, and one table is updated more frequently than the other.

Issue Links

• relates to: CASSANDRA-13508 Make system.paxos table compaction strategy configurable