cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phil Budne <p...@ultimate.com>
Subject Using DTCS, TTL but old SSTables not being removed
Date Sun, 13 Sep 2015 17:54:12 GMT
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: []

Mime
View raw message