Guidelines for configuring Thresholds for Cassandra metrics

2016-08-26 Thread Thomas Julian
Hello, I am working on setting up a monitoring tool to monitor Cassandra Instances. Are there any wikis which specifies optimum value for each Cassandra KPIs? For instance, I am not sure, What value of "Memtable Columns Count" can be considered as "Normal". What value of the same has to be

Re: Guidelines for configuring Thresholds for Cassandra metrics

2016-09-01 Thread Thomas Julian
her customer 100 is. The better approach is to establish a baseline for when these metrics start to indicate a serious issue is occurring in that particular app. Basically when people notice a problem, what did these numbers look like in the minutes, hours and days prior? That's the way to

Optimal value for concurrent_reads for a single NVMe Disk

2016-09-20 Thread Thomas Julian
Hello, We are using Cassandra 2.1.13 with each node having a NVMe disk with the configuration of Total Capacity - 1.2TB, Alloted Capacity - 880GB. We would like to increase the default value of 32 for the param concurrent_reads. But the document says "(Default: 32)note For workloads with

How to alter the default value for concurrent_compactors

2016-09-20 Thread Thomas Julian
Hello, We have commented out "concurrent_compactors" in our Cassandra 2.1.13 installation. We would like to review this setting, as some issues indicate that the default configuration may affect read/write performance. https://issues.apache.org/jira/browse/CASSANDRA-8787 https://issues.

Optimising the data model for reads

2016-09-29 Thread Thomas Julian
Hello, I have created a column family for User File Management. CREATE TABLE "UserFile" ("USERID" bigint,"FILEID" text,"FILETYPE" int,"FOLDER_UID" text,"FILEPATHINFO" text,"JSONCOLUMN" text,PRIMARY KEY ("USERID","FILEID")); Sample Entry (4*003, 3f9**

How to throttle up/down compactions without a restart

2016-10-20 Thread Thomas Julian
Hello, I was going through this presentation and the Slide-55 caught my attention. i.e) "Throttled down compactions during high load period, throttled up during low load period" Can we throttle down compactions without a restart? If this can be done, what are all the parameters(JMX

How to calculate CPU Utilisation on each node?

2017-01-10 Thread Thomas Julian
Hello, We are using Cassandra 2.1.13. We are calculating node CPU utilization using the below formula, CPUUsage = CPURate / (AvailableProcessors*100) CPURate = (x2-x1)/(t2-t1), where x2 and x1 are the values of the attribute ProcessCpuTime at the time t2 and t1 respectively. W

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