cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saladi Naidu <>
Subject system_distributed.repair_history table
Date Wed, 05 Oct 2016 21:23:33 GMT
We are seeing following warnings in system.log,  As compaction_large_partition_warning_threshold_mb 
in cassandra.yaml file is as default value 100, we are seeing these warnings
110:WARN  [CompactionExecutor:91798] 2016-10-05 00:54:05,554 - Writing
large partition system_distributed/repair_history:gccatmer:mer_admin_job (115943239 bytes)
111:WARN  [CompactionExecutor:91798] 2016-10-05 00:54:13,303 - Writing
large partition system_distributed/repair_history:gcconfigsrvcks:user_activation (163926097

When I looked at the table definition it is partitioned by keyspace and cloumnfamily, under
this partition, repair history is maintained. When I looked at the count of rows in this partition,
most of the paritions have >200,000 rows and these will keep growing because of the partition
strategy right. There is no TTL on this so any idea what is the solution for reducing partition

I also looked at size_estimates table for this column family and found that the mean partition
size for each range is 50,610,179 which is very large compared to any other tables. 
View raw message