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
<[email protected]> wrote:
On Wed, Dec 7, 2016 at 6:35 PM, Sotirios Delimanolis
<[email protected]> 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
[email protected]
