[ https://issues.apache.org/jira/browse/CASSANDRA-13508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jay Zhuang updated CASSANDRA-13508: ----------------------------------- 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: !test1.png | height=450,width=650! The time window for TWCS is set to 2 minutes for the test. Here is the p99 latency impact: !test2.png! the yellow one is LCS, the purple one is TWCS. Average p99 has about 10% increase. was: 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: !test1.png! The time window for TWCS is set to 2 minutes for the test. Here is the p99 latency impact: !test2.png! the yellow one is LCS, the purple one is TWCS. Average p99 has about 10% increase. > Make system.paxos table compaction strategy configurable and make TWCS as > default > --------------------------------------------------------------------------------- > > Key: CASSANDRA-13508 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13508 > Project: Cassandra > Issue Type: Improvement > Reporter: Jay Zhuang > Assignee: Jay Zhuang > Fix For: 4.0, 4.x > > Attachments: test1.png, test2.png > > > 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: > !test1.png | height=450,width=650! > The time window for TWCS is set to 2 minutes for the test. > Here is the p99 latency impact: > !test2.png! > the yellow one is LCS, the purple one is TWCS. Average p99 has about 10% > increase. -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org