What do you mean? I'm logging the list of files when creating the CompactionTask and it's showing these -rw-r--r-- 1 user group 3540336 Dec 7 23:40 lb-29715834-big-Data.db-rw-r--r-- 1 user group 5997853 Dec 7 22:07 lb-29715833-big-Data.db-rw-r--r-- 1 user group 5210561 Dec 7 20:34 lb-29715832-big-Data.db-rw-r--r-- 1 user group 9280836 Dec 7 19:01 lb-29715831-big-Data.db-rw-r--r-- 1 user group 6161434 Dec 7 17:26 lb-29715830-big-Data.db-rw-r--r-- 1 user group 6370388 Dec 7 16:02 lb-29715829-big-Data.db-rw-r--r-- 1 user group 5333813 Dec 7 14:37 lb-29715828-big-Data.db-rw-r--r-- 1 user group 3201999 Dec 7 13:02 lb-29715827-big-Data.db-rw-r--r-- 1 user group 2358003 Dec 7 11:08 lb-29715826-big-Data.db-rw-r--r-- 1 user group 1529995 Dec 7 08:50 lb-29715825-big-Data.db-rw-r--r-- 1 user group 4318164 Dec 7 06:18 lb-29715824-big-Data.db-rw-r--r-- 1 user group 4992116 Dec 7 04:04 lb-29715823-big-Data.db-rw-r--r-- 1 user group 3935687 Dec 7 02:21 lb-29715822-big-Data.db-rw-r--r-- 1 user group 52641621 Dec 7 01:19 lb-29713870-big-Data.db-rw-r--r-- 1 user group 210914040 Dec 7 01:19 lb-29713865-big-Data.db-rw-r--r-- 1 user group 210009811 Dec 7 01:18 lb-29713861-big-Data.db-rw-r--r-- 1 user group 209900194 Dec 7 01:18 lb-29713857-big-Data.db-rw-r--r-- 1 user group 210341449 Dec 7 01:18 lb-29713852-big-Data.db-rw-r--r-- 1 user group 209886959 Dec 7 01:05 lb-29713341-big-Data.db-rw-r--r-- 1 user group 210582486 Dec 7 01:05 lb-29713338-big-Data.db-rw-r--r-- 1 user group 211389548 Dec 7 01:00 lb-29713163-big-Data.db-rw-r--r-- 1 user group 212258569 Dec 7 01:00 lb-29713158-big-Data.db-rw-r--r-- 1 user group 210187074 Dec 7 00:58 lb-29713093-big-Data.db-rw-r--r-- 1 user group 20741012144 Dec 4 12:57 lb-29685218-big-Data.db-rw-r--r-- 1 user group 212429252597 Dec 1 08:20 lb-29678145-big-Data.db-rw-r--r-- 1 user group 78444316655 Dec 1 03:58 lb-29677495-big-Data.db-rw-r--r-- 1 user group 138933736915 Dec 1 03:41 lb-29677471-big-Data.db-rw-r--r-- 1 user group 1299907313 Nov 28 16:45 lb-29675769-big-Data.db-rw-r--r-- 1 user group 9133813452 Nov 28 12:57 lb-29675721-big-Data.db-rw-r--r-- 1 user group 41138758221 Nov 28 12:40 lb-29675715-big-Data.db-rw-r--r-- 1 user group 65810157304 Nov 28 06:42 lb-29675547-big-Data.db-rw-r--r-- 1 user group 39054510979 Nov 25 13:43 lb-29672887-big-Data.db-rw-r--r-- 1 user group 40439104157 Nov 23 11:16 lb-29670672-big-Data.db Running sstablemetadata on these gives me SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715834-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715833-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715832-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715831-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715830-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715829-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715828-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715827-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715826-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715825-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715824-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715823-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29715822-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713870-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713865-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713861-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713857-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713852-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713341-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713338-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713163-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713158-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29713093-bigSSTable max local deletion time: 2147483647SSTable Level: 1SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29685218-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29678145-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29677495-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29677471-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29675769-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29675721-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29675715-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29675547-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29672887-bigSSTable max local deletion time: 2147483647SSTable Level: 0SSTable: /var/cassandra/data/Keyspace1/Table1/lb-29670672-bigSSTable max local deletion time: 2147483647SSTable Level: 0 There's a mix of level 0 and level 1, but the 0 are definitely the bigger ones.
On Thursday, December 8, 2016 9:01 AM, Eric Evans <john.eric.ev...@gmail.com> wrote: On Wed, Dec 7, 2016 at 6:35 PM, Sotirios Delimanolis <sotodel...@yahoo.com> wrote: > I have a couple of SSTables that are humongous > > -rw-r--r-- 1 user group 138933736915 Dec 1 03:41 lb-29677471-big-Data.db > -rw-r--r-- 1 user group 78444316655 Dec 1 03:58 lb-29677495-big-Data.db > -rw-r--r-- 1 user group 212429252597 Dec 1 08:20 lb-29678145-big-Data.db > > sstablemetadata reports that these are all in SSTable Level 0. This table is > running with > > compaction = {'sstable_size_in_mb': '200', 'tombstone_threshold': '0.25', > 'tombstone_compaction_interval': '300', 'class': > 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'} > > How could this happen? The subject says level 1 and 0; What does level 1 look like? -- Eric Evans john.eric.ev...@gmail.com