I need something to keep the deleted columns away from my query fetch. Not
only the tombstones.
It looks like the min compaction might help on this. But I'm not sure yet on
what would be a reasonable value for its threeshold.
Your tombstones will not be purged in a compaction until after
Hello guys.
I'm investigating the reasons of performance degradation for my case
scenario which follows:
- I do have a column family which is filled of thousands of columns inside
a unique row(varies between 10k ~ 200k). And I do have also thousands of
rows, not much more than 15k.
- This rows
When is the last time you did a cleanup on the cf?
On Mar 2, 2013, at 9:48 AM, Víctor Hugo Oliveira Molinar
vhmoli...@gmail.com wrote:
Hello guys.
I'm investigating the reasons of performance degradation for my case scenario
which follows:
- I do have a column family which is filled of
I have a daily maintenance of my cluster where I truncate this column
family. Because its data doesnt need to be kept more than a day.
Since all the regular operations on it finishes around 4 hours before
finishing the day. I regurlarly run a truncate on it followed by a repair
at the end of the
What is your gc_grace set to? Sounds like as the number of tombstones records
increase your performance decreases. (Which I would expect)
On Mar 2, 2013, at 10:28 AM, Víctor Hugo Oliveira Molinar
vhmoli...@gmail.commailto:vhmoli...@gmail.com wrote:
I have a daily maintenance of my cluster
Casandra's data files are write once. Deletes are another write. Until
compaction they all live on disk.Making really big rows has these problem.
On Sat, Mar 2, 2013 at 1:42 PM, Michael Kjellman mkjell...@barracuda.comwrote:
What is your gc_grace set to? Sounds like as the number of tombstones
What is your gc_grace set to? Sounds like as the number of tombstones
records increase your performance decreases. (Which I would expect)
gr_grace is default.
Casandra's data files are write once. Deletes are another write. Until
compaction they all live on disk.Making really big rows has
Tombstones stay around until gc grace so you could lower that to see of that
fixes the performance issues.
Size tiered or leveled comparison?
On Mar 2, 2013, at 11:15 AM, Víctor Hugo Oliveira Molinar
vhmoli...@gmail.commailto:vhmoli...@gmail.com wrote:
What is your gc_grace set to? Sounds
Tombstones stay around until gc grace so you could lower that to see of
that fixes the performance issues.
If the tombstones get collected,the column will live again, causing data
inconsistency since I cant run a repair during the regular operations. Not
sure if I got your thoughts on this.