Re: Large sstables

2018-09-06 Thread Vitali Dyachuk
What i have done is: 1) added more disks, so the compaction will carry on 2) when i've switched to LCS from STCS the STCS queues for the processing big sstables have remained, so i've stopped these queues with nodetool stop -id queue_id and LCS compaction has started to process sstables , i'm u

Re: Large sstables

2018-09-01 Thread shalom sagges
If there are a lot of droppable tombstones, you could also run User Defined Compaction on that (and on other) SSTable(s). This blog post explains it well: http://thelastpickle.com/blog/2016/10/18/user-defined-compaction.html On Fri, Aug 31, 2018 at 12:04 AM Mohamadreza Rostami < mohamadrezarosta.

Re: Large sstables

2018-08-30 Thread Mohamadreza Rostami
Hi,Dear Vitali The best option for you is migrating data to the new table and change portion key patterns to a better distribution of data and you sstables become smaller but if your data already have good distribution and your data is really big you must add new server to your datacenter, if yo

Re: Large sstables

2018-08-30 Thread Jeff Jirsa
Either of those are options, but there’s also sstablesplit to break it up a bit Switching to LCS can be a problem depending on how many sstables /overlaps you have -- Jeff Jirsa > On Aug 30, 2018, at 8:05 AM, Vitali Dyachuk wrote: > > Hi, > Some of the sstables got too big 100gb and more s