Could someone guide to what the best JVM Memory settings would be for Apache Cassandra ?
I have read a couple of postings here, but did not find any guideline.
The more memory I have I can utilise the bloom filters, key and row cache better, that is pretty much it. But how can I know if I need 12 gig, 24 Gig, 32 Gig, 64 Gig, 128.... of heap. Is there some sort of metric I can look at to see when it is time to increase memory or even shrink.
I need to be carful, and ensure that I use G1 when moving above 12 Gig and not move beyond 64 Gig due to Linux page cache.
https://cassandra.apache.org/doc/latest/operating/hardware.html
Today one of the systems I investigate has 64 Gig, which strikes me as way too much
But I need to motivate that, so how would I be able to tell what is a good number of our situation.
So if you have any good articles to share that would be great