我正在将压实策略从大小更改为级别?有没有办法检查压实是否发生了变化?
登录到 cqlsh 并检查表结构。
$cqlsh> desc keyspacebname.tablename;
您将看到表压缩类:
CREATE TABLE keyspacebname.tablename (
.....
PRIMARY KEY (..)
) WITH CLUSTERING ORDER BY (... DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
...
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
....
您还可以通过节点工具检查压缩状态:
$> nodetool compactionstats
有关更多详细信息,请查看以下链接:Nodetool CompactionStats
您可以通过查询找到压缩信息:
对于卡桑德拉版本 <3
SELECT compaction_strategy_class,compaction_strategy_options,max_compaction_threshold, min_compaction_threshold FROM system.schema_columnfamilies WHERE keyspace_name = 'your_keyspace_name' AND columnfamily_name = 'your_table_name';
对于卡桑德拉版本>= 3
SELECT compaction FROM system_schema.tables WHERE keyspace_name = 'your_keyspace_name' AND table_name = 'your_table_name' ;