Hi, Any idea when 2.2.2 will be released? I see there are still 3 issues left to fix: https://issues.apache.org/jira/browse/CASSANDRA/fixforversion/12333319/?selectedTab=com.atlassian.jira.jira-projects-plugin:version-summary-panel
-- Jacques-Henri Berthemet -----Original Message----- From: Jeff Jirsa [mailto:jeff.ji...@crowdstrike.com] Sent: dimanche 13 septembre 2015 20:34 To: user@cassandra.apache.org Subject: Re: Using DTCS, TTL but old SSTables not being removed 2.2.1 has a pretty significant bug in compaction: https://issues.apache.org/jira/browse/CASSANDRA-10270 That prevents it from compacting files after 60 minutes. It may or may not be the cause of the problem you’re seeing, but it seems like it may be possibly related, and you can try the workaround in that ticket to see if it helps. On 9/13/15, 10:54 AM, "Phil Budne" <p...@ultimate.com> wrote: >Running Cassandra 2.2.1 on 3 nodes (on EC2, from Datastax AMI, then >upgraded). Inserting time-series data; All entries with TTL to expire >3 hours after the "actual_time" of the observation. Entries arrive >with varied delay, and often in duplicate. Data is expiring (no longer >visible from CQL), but old SSTables are not being removed (except on >restart). > >CREATE KEYSPACE thing > WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '2'} > AND durable_writes = true; > >CREATE TABLE thing.thing_ia ( > id int, > actual_time timestamp, > data text, > PRIMARY KEY (id, actual_time) >) WITH CLUSTERING ORDER BY (actual_time ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'tombstone_threshold': '0.1', > 'tombstone_compaction_interval': '600', 'class': > 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 60 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > >All times shown in UTC: > >$ python -c 'import time; print int(time.time())' >1442166347 > >$ date >Sun Sep 13 17:46:19 UTC 2015 > >$ cat ~/mmm.sh >for x in la-*Data.db; do > ls -l $x > ~/meta.sh $x >/tmp/mmm/$x > head < /tmp/mmm/$x > echo .... > grep Ances /tmp/mmm/$x > echo '' >done > >$ sh ~/mmm.sh >-rw-r--r-- 1 cassandra cassandra 31056032 Sep 12 05:41 la-203-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-203-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442025790163000 >Maximum timestamp: 1442034620451000 >SSTable max local deletion time: 1442045239 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.946418951062831 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [202] > >-rw-r--r-- 1 cassandra cassandra 23647585 Sep 12 06:09 la-204-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-204-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442034620472000 >Maximum timestamp: 1442038188419002 >SSTable max local deletion time: 1442073136 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9163514458998852 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23456946 Sep 12 07:25 la-205-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-205-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442038188472000 >Maximum timestamp: 1442042703834001 >SSTable max local deletion time: 1442053303 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9442594560554178 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23331024 Sep 12 08:11 la-206-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-206-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442042703845000 >Maximum timestamp: 1442045482391000 >SSTable max local deletion time: 1442056194 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.922422134865437 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23699494 Sep 12 09:11 la-207-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-207-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442045482398001 >Maximum timestamp: 1442049092160000 >SSTable max local deletion time: 1442059681 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9327568753815364 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23900518 Sep 12 10:11 la-208-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-208-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442049092164001 >Maximum timestamp: 1442052684468000 >SSTable max local deletion time: 1442063293 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9249749035769007 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24471823 Sep 12 11:08 la-209-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-209-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442052684479001 >Maximum timestamp: 1442056105350000 >SSTable max local deletion time: 1442066673 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8992881460848035 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24710399 Sep 12 12:00 la-210-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-210-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442056105354001 >Maximum timestamp: 1442059246020000 >SSTable max local deletion time: 1442070044 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9013363868274582 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24891451 Sep 12 12:39 la-211-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-211-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442059246027001 >Maximum timestamp: 1442061582169000 >SSTable max local deletion time: 1442072253 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.955867029939103 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25219480 Sep 12 13:23 la-212-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-212-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442061582191001 >Maximum timestamp: 1442064187557001 >SSTable max local deletion time: 1442074833 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9414074140294416 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23833245 Sep 12 14:06 la-213-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-213-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442064187566001 >Maximum timestamp: 1442066806163001 >SSTable max local deletion time: 1442077346 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9258127717616264 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25131528 Sep 12 14:41 la-214-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-214-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442066806174001 >Maximum timestamp: 1442068878034000 >SSTable max local deletion time: 1442079643 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9003925240375958 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25562260 Sep 12 15:24 la-215-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-215-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442068878043000 >Maximum timestamp: 1442071442776001 >SSTable max local deletion time: 1442082099 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9564359579100146 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23643253 Sep 12 16:06 la-216-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-216-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442071442794000 >Maximum timestamp: 1442073999829000 >SSTable max local deletion time: 1442084637 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9192411626511459 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23546185 Sep 12 16:38 la-217-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-217-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442073999841000 >Maximum timestamp: 1442075898083000 >SSTable max local deletion time: 1442086660 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8964492565279292 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25147038 Sep 12 17:16 la-218-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-218-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442075898107000 >Maximum timestamp: 1442078170120001 >SSTable max local deletion time: 1442088843 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8938063895607985 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 45905849 Sep 12 18:44 la-221-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-221-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442078170123000 >Maximum timestamp: 1442083450036000 >SSTable max local deletion time: 1442094133 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9332465957414146 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [220, 219] > >-rw-r--r-- 1 cassandra cassandra 23472968 Sep 12 19:33 la-222-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-222-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442083450046000 >Maximum timestamp: 1442086395513001 >SSTable max local deletion time: 1442097309 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9095983957509078 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25350304 Sep 12 20:12 la-223-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-223-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442086395527001 >Maximum timestamp: 1442088746975001 >SSTable max local deletion time: 1442099467 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9007539214635366 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23458453 Sep 12 21:05 la-224-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-224-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442088746985000 >Maximum timestamp: 1442091930609001 >SSTable max local deletion time: 1442102425 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9316843483187777 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22849937 Sep 12 21:46 la-225-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-225-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442091930628000 >Maximum timestamp: 1442094362388001 >SSTable max local deletion time: 1442105035 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9054959369766143 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24267023 Sep 12 22:44 la-226-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-226-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442094362398001 >Maximum timestamp: 1442097848918000 >SSTable max local deletion time: 1442108617 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8951104269557223 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24537368 Sep 12 23:50 la-227-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-227-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442097848933001 >Maximum timestamp: 1442101803065000 >SSTable max local deletion time: 1442112470 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9331192321889996 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22552359 Sep 13 00:55 la-228-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-228-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442101803074000 >Maximum timestamp: 1442105711281000 >SSTable max local deletion time: 1442159089 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9132899137475796 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22715355 Sep 13 02:07 la-229-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-229-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442105711284000 >Maximum timestamp: 1442110043391001 >SSTable max local deletion time: 1442159990 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9098589365989769 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 21741125 Sep 13 03:32 la-230-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-230-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442110043397001 >Maximum timestamp: 1442115126772000 >SSTable max local deletion time: 1442125783 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9095717963207133 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 21468064 Sep 13 05:13 la-231-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-231-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442115126776000 >Maximum timestamp: 1442121182921000 >SSTable max local deletion time: 1442159995 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9144513339510132 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23130171 Sep 13 07:26 la-232-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-232-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442121182924000 >Maximum timestamp: 1442129165932000 >SSTable max local deletion time: 1442139778 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9227580090899014 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22655568 Sep 13 09:24 la-233-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-233-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442129165945001 >Maximum timestamp: 1442136244212000 >SSTable max local deletion time: 1442146856 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9253930802770909 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22021359 Sep 13 11:06 la-234-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-234-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442136244215000 >Maximum timestamp: 1442142379553001 >SSTable max local deletion time: 1442153015 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9030365649318737 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22017981 Sep 13 12:26 la-235-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-235-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442142379563000 >Maximum timestamp: 1442147168003000 >SSTable max local deletion time: 1442157819 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9298967746084831 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22471128 Sep 13 13:35 la-236-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-236-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442147168005000 >Maximum timestamp: 1442151311137000 >SSTable max local deletion time: 1442161999 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9320140286599256 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23013996 Sep 13 14:34 la-237-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-237-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442151311143000 >Maximum timestamp: 1442154879033000 >SSTable max local deletion time: 1442165568 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8982069452113627 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23000960 Sep 13 15:24 la-238-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-238-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442154879045001 >Maximum timestamp: 1442157851158000 >SSTable max local deletion time: 1442168531 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.503868324427705 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24236245 Sep 13 16:16 la-239-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-239-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442157851166000 >Maximum timestamp: 1442160965505001 >SSTable max local deletion time: 1442171653 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.021412903717582046 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22916513 Sep 13 17:09 la-240-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-240-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442160965529001 >Maximum timestamp: 1442164175417001 >SSTable max local deletion time: 1442174798 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.013147684371029453 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] >-rw-r--r-- 1 cassandra cassandra 31056032 Sep 12 05:41 la-203-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-203-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442025790163000 >Maximum timestamp: 1442034620451000 >SSTable max local deletion time: 1442045239 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.946418951062831 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [202] > >-rw-r--r-- 1 cassandra cassandra 23647585 Sep 12 06:09 la-204-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-204-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442034620472000 >Maximum timestamp: 1442038188419002 >SSTable max local deletion time: 1442073136 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9163514458998852 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23456946 Sep 12 07:25 la-205-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-205-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442038188472000 >Maximum timestamp: 1442042703834001 >SSTable max local deletion time: 1442053303 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9442594560554178 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23331024 Sep 12 08:11 la-206-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-206-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442042703845000 >Maximum timestamp: 1442045482391000 >SSTable max local deletion time: 1442056194 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.922422134865437 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23699494 Sep 12 09:11 la-207-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-207-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442045482398001 >Maximum timestamp: 1442049092160000 >SSTable max local deletion time: 1442059681 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9327568753815364 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23900518 Sep 12 10:11 la-208-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-208-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442049092164001 >Maximum timestamp: 1442052684468000 >SSTable max local deletion time: 1442063293 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9249749035769007 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24471823 Sep 12 11:08 la-209-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-209-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442052684479001 >Maximum timestamp: 1442056105350000 >SSTable max local deletion time: 1442066673 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8992881460848035 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24710399 Sep 12 12:00 la-210-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-210-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442056105354001 >Maximum timestamp: 1442059246020000 >SSTable max local deletion time: 1442070044 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9013363868274582 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24891451 Sep 12 12:39 la-211-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-211-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442059246027001 >Maximum timestamp: 1442061582169000 >SSTable max local deletion time: 1442072253 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.955867029939103 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25219480 Sep 12 13:23 la-212-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-212-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442061582191001 >Maximum timestamp: 1442064187557001 >SSTable max local deletion time: 1442074833 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9414074140294416 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23833245 Sep 12 14:06 la-213-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-213-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442064187566001 >Maximum timestamp: 1442066806163001 >SSTable max local deletion time: 1442077346 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9258127717616264 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25131528 Sep 12 14:41 la-214-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-214-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442066806174001 >Maximum timestamp: 1442068878034000 >SSTable max local deletion time: 1442079643 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9003925240375958 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25562260 Sep 12 15:24 la-215-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-215-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442068878043000 >Maximum timestamp: 1442071442776001 >SSTable max local deletion time: 1442082099 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9564359579100146 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23643253 Sep 12 16:06 la-216-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-216-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442071442794000 >Maximum timestamp: 1442073999829000 >SSTable max local deletion time: 1442084637 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9192411626511459 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23546185 Sep 12 16:38 la-217-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-217-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442073999841000 >Maximum timestamp: 1442075898083000 >SSTable max local deletion time: 1442086660 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8964492565279292 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25147038 Sep 12 17:16 la-218-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-218-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442075898107000 >Maximum timestamp: 1442078170120001 >SSTable max local deletion time: 1442088843 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8938063895607985 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 45905849 Sep 12 18:44 la-221-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-221-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442078170123000 >Maximum timestamp: 1442083450036000 >SSTable max local deletion time: 1442094133 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9332465957414146 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [220, 219] > >-rw-r--r-- 1 cassandra cassandra 23472968 Sep 12 19:33 la-222-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-222-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442083450046000 >Maximum timestamp: 1442086395513001 >SSTable max local deletion time: 1442097309 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9095983957509078 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 25350304 Sep 12 20:12 la-223-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-223-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442086395527001 >Maximum timestamp: 1442088746975001 >SSTable max local deletion time: 1442099467 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9007539214635366 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23458453 Sep 12 21:05 la-224-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-224-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442088746985000 >Maximum timestamp: 1442091930609001 >SSTable max local deletion time: 1442102425 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9316843483187777 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22849937 Sep 12 21:46 la-225-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-225-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442091930628000 >Maximum timestamp: 1442094362388001 >SSTable max local deletion time: 1442105035 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9054959369766143 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24267023 Sep 12 22:44 la-226-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-226-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442094362398001 >Maximum timestamp: 1442097848918000 >SSTable max local deletion time: 1442108617 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8951104269557223 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24537368 Sep 12 23:50 la-227-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-227-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442097848933001 >Maximum timestamp: 1442101803065000 >SSTable max local deletion time: 1442112470 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9331192321889996 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22552359 Sep 13 00:55 la-228-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-228-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442101803074000 >Maximum timestamp: 1442105711281000 >SSTable max local deletion time: 1442159089 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9132899137475796 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22715355 Sep 13 02:07 la-229-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-229-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442105711284000 >Maximum timestamp: 1442110043391001 >SSTable max local deletion time: 1442159990 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9098589365989769 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 21741125 Sep 13 03:32 la-230-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-230-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442110043397001 >Maximum timestamp: 1442115126772000 >SSTable max local deletion time: 1442125783 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9095717963207133 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 21468064 Sep 13 05:13 la-231-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-231-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442115126776000 >Maximum timestamp: 1442121182921000 >SSTable max local deletion time: 1442159995 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9144513339510132 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23130171 Sep 13 07:26 la-232-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-232-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442121182924000 >Maximum timestamp: 1442129165932000 >SSTable max local deletion time: 1442139778 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9227580090899014 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22655568 Sep 13 09:24 la-233-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-233-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442129165945001 >Maximum timestamp: 1442136244212000 >SSTable max local deletion time: 1442146856 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9253930802770909 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22021359 Sep 13 11:06 la-234-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-234-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442136244215000 >Maximum timestamp: 1442142379553001 >SSTable max local deletion time: 1442153015 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9030365649318737 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22017981 Sep 13 12:26 la-235-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-235-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442142379563000 >Maximum timestamp: 1442147168003000 >SSTable max local deletion time: 1442157819 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9298967746084831 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22471128 Sep 13 13:35 la-236-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-236-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442147168005000 >Maximum timestamp: 1442151311137000 >SSTable max local deletion time: 1442161999 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.9320140286599256 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23013996 Sep 13 14:34 la-237-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-237-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442151311143000 >Maximum timestamp: 1442154879033000 >SSTable max local deletion time: 1442165568 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.8982069452113627 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 23000960 Sep 13 15:24 la-238-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-238-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442154879045001 >Maximum timestamp: 1442157851158000 >SSTable max local deletion time: 1442168531 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.503868324427705 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 24236245 Sep 13 16:16 la-239-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-239-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442157851166000 >Maximum timestamp: 1442160965505001 >SSTable max local deletion time: 1442171653 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.021412903717582046 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: [] > >-rw-r--r-- 1 cassandra cassandra 22916513 Sep 13 17:09 la-240-big-Data.db >SSTable: /raid0/cassandra/data/thing.thing_ia-.........../la-240-big >Partitioner: org.apache.cassandra.dht.Murmur3Partitioner >Bloom Filter FP chance: 0.010000 >Minimum timestamp: 1442160965529001 >Maximum timestamp: 1442164175417001 >SSTable max local deletion time: 1442174798 >Compression ratio: -1.0 >Estimated droppable tombstones: 0.013147684371029453 >SSTable Level: 0 >Repaired at: 0 >.... >Ancestors: []
