[
https://issues.apache.org/jira/browse/CASSANDRA-18534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773350#comment-17773350
]
Maxwell Guo commented on CASSANDRA-18534:
-----------------------------------------
I have completed the first version. [~blambov] [~jlewandowski] can you help to
take a look ?
There may be some places that need to be modified after the first round of
review, or may be some implementation details need to be discussed (for example
: does the sstable type like big or bti format should also be per table
configurable which I left a todo for this). Regardless, we need to move this
matter forward.
This patch do not include the "row_index_granularity" and I hope to do it in
18533. Because in CASSANDRA-18533 there is a description said
“column_index_size, which should also be renamed to row_index_granularity”.
|trunk|[pr-trunk|https://github.com/apache/cassandra/pull/2786]|
|java11|[pre-commit|https://app.circleci.com/pipelines/github/Maxwell-Guo/cassandra/504/workflows/a70148cc-1235-4d09-bde1-b00e430531e4]|
|java17|[pre-commit|https://app.circleci.com/pipelines/github/Maxwell-Guo/cassandra/504/workflows/e6facf67-b5c0-4606-bbba-394c5f143123]|
> Make sstable format configurable per table
> ------------------------------------------
>
> Key: CASSANDRA-18534
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18534
> Project: Cassandra
> Issue Type: Improvement
> Components: Cluster/Schema, Local/SSTable
> Reporter: Branimir Lambov
> Assignee: Maxwell Guo
> Priority: Normal
> Fix For: 5.x
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Some SSTable format settings need to be configurable per table for better
> efficiency. This includes:
> - {{row_index_granularity}}
> - {{bloom_filter_fp_chance}}
> - {{crc_check_chance}}
> - {{min/max_index_interval}}
> Some of these are currently configurable using direct properties of tables.
> Having them as format properties makes better sense and should also support
> specifying useable combinations of settings, e.g.
> {code:java}
> CREATE TABLE ... WITH sstable_format = "bti-fast";
> CREATE TABLE ... WITH sstable_format = "bti-small";
> {code}
> where {{bti-fast}} and {{bti-small}} can be defined in {{cassandra.yaml}}
> e.g. as
> {code:java}
> sstable.format.options:
> - bti-fast:
> row_index_granularity: 1kiB
> bloom_filter_fp_chance: 0.01
> - bti-small:
> row_index_granularity: 32kiB
> bloom_filter_fp_chance: 0.1
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
