Re: Row cache tuning

2017-03-12 Thread Thomas Julian
Hi Matija, ​Leveraging page cache yields good results and if accounted for can provide you with performance increase on read side ​ I would like to leverage the page cache to improve read performance. How this can be done? Best Regards, Julian. On Mon, 13 Mar 2017 03:42:3

Re: Row cache tuning

2017-03-12 Thread preetika tyagi
I see. Thanks, Arvydas! In terms of eviction policy in the row cache, does a write operation invalidates only the row(s) which are going be modified or the whole partition? In older version of Cassandra, I believe the whole partition gets invalidated even if only one row is modified. Is that still

Re: Row cache tuning

2017-03-12 Thread Arvydas Jonusonis
You can experiment quite easily without even needing to restart the Cassandra service. The caches (row and key) can be enabled on a table-by-table basis via a schema directive. But the cache capacity (which is the one that you referred to in your original post, set to 0 in cassandra.yaml) is a glo

Re: Row cache tuning

2017-03-12 Thread preetika tyagi
Thanks, Matija! That was insightful. I don't really have a use case in particular, however, what I'm trying to do is to figure out how the Cassandra performance can be leveraged by using different caching mechanisms, such as row cache, key cache, partition summary etc. Of course, it will also heav

Re: Row cache tuning

2017-03-11 Thread Matija Gobec
Hi, In 99% of use cases Cassandra's row cache is not something you should look into. Leveraging page cache yields good results and if accounted for can provide you with performance increase on read side. I'm not a fan of a default row cache implementation and its invalidation mechanism on updates

Row cache tuning

2017-03-11 Thread preetika tyagi
Hi, I'm new to Cassandra and trying to get a better understanding on how the row cache can be tuned to optimize the performance. I came across think this article: https://docs.datastax.com/en/cassandra/3.0/cassandra/operations/opsConfiguringCaches.html And it suggests not to even touch row cache