No it does not exist. Rob and I might start a donation page and give the money to whoever is willing to code it. If someone would write a tool that would split an sstable into 4 smaller sstables (even an offline command line tool) I would paypal them a hundo.
On Sat, Nov 10, 2012 at 1:10 PM, Aaron Turner <synfina...@gmail.com> wrote: > Nope. I think at least once a week I hear someone suggest one way to solve > their problem is to "write an sstablesplit tool". > > I'm pretty sure that: > > Step 1. Write sstablesplit > Step 2. ??? > Step 3. Profit! > > > > On Sat, Nov 10, 2012 at 9:40 AM, Alain RODRIGUEZ <arodr...@gmail.com> wrote: >> >> @Rob Coli >> >> Does the "sstablesplit" function exists somewhere ? >> >> >> >> 2012/11/10 Jim Cistaro <jcist...@netflix.com> >>> >>> For some of our clusters, we have taken the periodic major compaction >>> route. >>> >>> There are a few things to consider: >>> 1) Once you start major compacting, depending on data size, you may be >>> committed to doing it periodically because you create one big file that >>> will take forever to naturally compact agaist 3 like sized files. >>> 2) If you rely heavily on file cache (rather than large row caches), each >>> major compaction effectively invalidates the entire file cache beause >>> everything is written to one new large file. >>> >>> -- >>> Jim Cistaro >>> >>> On 11/9/12 11:27 AM, "Rob Coli" <rc...@palominodb.com> wrote: >>> >>> >On Thu, Nov 8, 2012 at 10:12 AM, B. Todd Burruss <bto...@gmail.com> >>> > wrote: >>> >> my question is would leveled compaction help to get rid of the >>> >>tombstoned >>> >> data faster than size tiered, and therefore reduce the disk space >>> >> usage? >>> > >>> >You could also... >>> > >>> >1) run a major compaction >>> >2) code up sstablesplit >>> >3) profit! >>> > >>> >This method incurs a management penalty if not automated, but is >>> >otherwise the most efficient way to deal with tombstones and obsolete >>> >data.. :D >>> > >>> >=Rob >>> > >>> >-- >>> >=Robert Coli >>> >AIM>ALK - rc...@palominodb.com >>> >YAHOO - rcoli.palominob >>> >SKYPE - rcoli_palominodb >>> > >>> >> > > > > -- > Aaron Turner > http://synfin.net/ Twitter: @synfinatic > http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & > Windows > Those who would give up essential Liberty, to purchase a little temporary > Safety, deserve neither Liberty nor Safety. > -- Benjamin Franklin > "carpe diem quam minimum credula postero" >