Cassandra performance slow down with counter column

Posted by tubcvt on Stack Overflow See other posts from Stack Overflow or by tubcvt
Published on 2012-10-15T03:33:06Z Indexed on 2012/10/15 3:36 UTC
Read the original article Hit count: 229

Filed under:

Performance

|

nosql

|

cassandra

|

hector

I have a cluster (4 node ) and a node have 16 core and 24 gb ram:

192.168.23.114  datacenter1 rack1       Up     Normal  44.48 GB        25.00%             
192.168.23.115  datacenter1 rack1       Up     Normal  44.51 GB        25.00%
192.168.23.116  datacenter1 rack1       Up     Normal  44.51 GB        25.00%
192.168.23.117  datacenter1 rack1       Up     Normal  44.51 GB        25.00%

We use about 10 column family (counter column) to make some system statistic report.

Problem on here is that When i set replication_factor of this keyspace from 1 to 2 (contain 10 counter column family ), all cpu of node increase from 10% ( when use replication factor=1) to ---> 90%. :( :(

who can help me work around that :( . why counter column consume too much cpu time :(.

thanks all

© Stack Overflow or respective owner

Related posts about Performance

Improving VPN performance - stronger encryption = more performance?

as seen on Server Fault - Search for 'Server Fault'
I have a site-to-site VPN set up with two SonicWall's (a TZ170 and a Pro1260). It was suggested to me that turning off encryption (so the VPN is tunneling only) would improve performance. (I'm not concerned with security, because the VPN is running over a trusted line.) Using FTP and HTTP transfers… >>> More
Inaccurate performance counter timer values in Windows Performance Monitor

as seen on Stack Overflow - Search for 'Stack Overflow'
I am implementing instrumentation within an application and have encountered an issue where the value that is displayed in Windows Performance Monitor from a PerformanceCounter is incongruent with the value that is recorded. I am using a Stopwatch to record the duration of a method execution, then… >>> More
Excel-based Performance Reviews transformed into Web Application for Performance Management

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
HR TMS provides enterprise talent management solutions for healthcare, retail and corporate customers, focusing on performance management, compensation management and succession planning. As the competency of nurses and other healthcare workers is critical, the government, via the Joint Commission… >>> More
How to save a perfmon Performance Counter as a textfile (Reliability and Performance Monitor Version

as seen on Server Fault - Search for 'Server Fault'
Now the file gets saved as blg, but I would like a txt versin to import in Excel. >>> More
SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010

as seen on SQL Authority - Search for 'SQL Authority'
This is report to my third of very successful seminar event on SQL Server Performance Tuning. SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand… >>> More

Related posts about nosql

???: Oracle NoSQL Database??

as seen on Oracle Blogs - Search for 'Oracle Blogs'
?????????Oracle?????Oracle NoSQL Database,?????NoSQL Database ??????????Oracle NoSQL Database??2???,Community Edition ?Enterprise Edition?????????NoSQL Database 11g R2 (11gR2.1.2.123). ?????????????????: Oracle NoSQL Database OTN portal (includes download facility) Oracle NoSQL Database… >>> More
Free NOSQL database for use with C# client [closed]

as seen on Programmers - Search for 'Programmers'
I've never used NOSQL databases before, but so far it seems like the best data storage solution for my project. I am going to implement a datamining application. The data I would like to mine is thousands of documents which cannot be imported into datamining applications. To make to import easier… >>> More
Big Data – Buzz Words: What is NoSQL – Day 5 of 21

as seen on SQL Authority - Search for 'SQL Authority'
In yesterday’s blog post we explored the basic architecture of Big Data . In this article we will take a quick look at one of the four most important buzz words which goes around Big Data – NoSQL. What is NoSQL? NoSQL stands for Not Relational SQL or Not Only SQL. Lots of people think… >>> More
Oracle Big Data Learning Library - Click on LEARN BY PRODUCT to Open Page

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Big Data Learning Library... Learn about Oracle Big Data, Data Science, Learning Analytics, Oracle NoSQL Database, and more! … >>> More
NoSQL with RavenDB and ASP.NET MVC - Part 1

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
A while back, I have blogged NoSQL with MongoDB, NoRM and ASP.NET MVC Part 1 and Part 2 on how to use MongoDB with an ASP.NET MVC application. The NoSQL movement is getting big attention and RavenDB is the latest addition to the NoSQL and document database world. RavenDB is an Open Source (with… >>> More