Thanks Robert, Can you please explain what problems DROP/CREATE keyspace may cause? Seems like truncate working per column family and I have up to 10. What I should I delete from disk in that case? I can't delete whole folder right? I need to delete all content under each cf folder, but not folders? Correct?
Pavel On Fri, Jun 20, 2014 at 6:01 PM, Robert Coli <rc...@eventbrite.com> wrote: > On Fri, Jun 20, 2014 at 2:48 PM, Pavel Kogan <pavel.ko...@cortica.com> > wrote: > >> So what we did is creating every hour new keyspace named yyyy_MM_dd_HH >> and when disk becomes full, script running in crontrab on each node drops >> keyspace with "IF EXISTS" flag, and deletes whole keyspace folder. That way >> whole process is very clean and no garbage is left on disk. >> > > I've recommended a similar technique in the past, but with alternating > between Keyspace_A and Keyspace_B. That way you just TRUNCATE them instead > of having to DROP. > > DROP/CREATE keyspace have problems that TRUNCATE do not. Perhaps use a > TRUNCATE oriented technique? > > =Rob > >