upgrade 2.1 to 3.0

2018-08-10 Thread kooljava2
Hello, We recently upgrade C* from 2.1 to 3.0. After the upgrade we are seeing increase in the  total read bytes and read ops on the EBS volumes. It almost doubled on all the nodes.  The number of writes are same. Thank you.

Cassandra caches

2018-08-10 Thread rajasekhar kommineni
Hi All, I had allocated 2 GB each for Key, Row, Counter & Chunk cache and performed below steps. Please note it is test box not others users are connected to it. Output 1 shows 0 hits and 0 requests - After clean startup of cassandra Output 2 shows 0 hits and 1 requests - Executed a select

Removing Extra Spaces and Row counts while using Capture Command

2018-08-10 Thread kumar bharath
Hi All, I am using Cassandra Capture Command to perform a select query operation to write data from a column family into JSON format file for further processing. I am able to do that successfully, but I am seeing extra spaces and row count values after every few records. please suggest a to get

Re: Extending Cassandra on AWS from single Region to Multi-Region

2018-08-10 Thread srinivasarao daruna
Hey All, Any info on this topic.? Thank You, Regards, Srini On Wed, Aug 8, 2018, 9:46 PM srinivasarao daruna wrote: > Hi All, > > We have built Cassandra on AWS EC2 instances. Initially when creating > cluster we have not considered multi-region deployment and we have used AWS > EC2Snitch. >

Re: Cassandra Compaction Metrics - CompletedTasks vs TotalCompactionCompleted

2018-08-10 Thread Dionne Cloudoupoulos
On 2017/10/31 16:56:29, Chris Lohfink wrote: > The "CompletedTasks" metric is a measure of how many tasks ran on these two > executors combined. > The "TotalCompactionsCompleted" metric is a measure of how many compactions > issued from the compaction manager ran (normal compactions, cache writes,

Re: Cassandra Compaction Metrics - CompletedTasks vs TotalCompactionCompleted

2018-08-10 Thread Chris Lohfink
If its occurring that often you can monitor nodetool compactionstats to see whats running > On Aug 10, 2018, at 11:35 AM, Dionne Cloudoupoulos > wrote: > > On 2017/10/31 16:56:29, Chris Lohfink wrote: >> The "CompletedTasks" metric is a measure of how many tasks ran on these two >> executors

Re: CQL data type compatibility between ascii and text

2018-08-10 Thread Y K
Hi Thira, First, there's the 3.0 branch of versions and the 3.x branch of versions. http://cassandra.apache.org/doc/latest/development/patches.html#choosing-the-right-branches-to-work-on The 3.0.16 belongs to the 3.0 branch. The 3.9 and 3.11.2 belong to the 3.x. branch I believe the change was

CQL data type compatibility between ascii and text

2018-08-10 Thread thiranjith
Hi, According to documentation at  https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cql_data_types_c.html#cql_data_types_c__cql_data_type_compatibility  we should not be able to change the column type from ascii to text. I have had a mix experience with conversion between data types on

Re: Huge daily outbound network traffic

2018-08-10 Thread Behnam B.Marandi
I don't have any external process or planed repair in that time period. In case of network, I can see outbound network on Cassandra node network interface but couldn't find any way to check the VPC network to make sure it is not going out of network. Maybe the only way is analysing VPC Flow Log.

difference between CompletedTasks and TotalComactionCompleted

2018-08-10 Thread Dionne Cloudoupoulos
Hello! I'm trying to monitor cassandra through jmx and it turns out that I find two values that seem to be the same thing but not: org.apache.cassandra.metrics: type = Compaction, name = CompletedTasks.Value org.apache.cassandra.metrics: type = Compaction, name = TotalCompactionsCompleted.Count

Re: CQL data type compatibility between ascii and text

2018-08-10 Thread thiranjith
Thanks Yoshi! That explains it a lot :) On Fri, 10 Aug 2018 18:30:25 +1000  Y K wrote Hi Thira, First, there's the 3.0 branch of versions and the 3.x branch of versions. http://cassandra.apache.org/doc/latest/development/patches.html#choosing-the-right-branches-to-work-on The 3.0.16

Re: difference between CompletedTasks and TotalComactionCompleted

2018-08-10 Thread Horia Mocioi
Hello, There has been a similar thread a few months back. https://lists.apache.org/thread.html/2cad65aba4fb035378591ef007ee68ccaf23a2c025aaaf7e7512d364@%3Cuser.cassandra.apache.org%3E On fre, 2018-08-10 at 14:18 +0200, Dionne Cloudoupoulos wrote: Hello! I'm trying to monitor cassandra through