CODEWITHSUNDEEP
cassandrabenchmarkingcassandra-3.0
Coder
Coder

Reputation: 3282

Read and Write Performance calculation in apache cassandra

I would like to track and calculate the READ and WRITE performance in Apache Cassandra (Client - cqlsh). I know TRACING ON is available, but I didn't find that much useful.

I expect to track the following examples in Cassandra (Examples), 

I have 3 node Cassandra cluster and I have a table with 1 million entry, I would like to calculate the performance of READ / WRITE in the following way,

1) WRITE - 1 INSERT with 1 million entry available in it.
2) WRITE - 1 UPSERT on one of the entry with 1 million entry available in it.
3) READ - 1 READ from 1 million entry 
4) READ - ALL THE 1 million entry

which involves single partition and multiple partition too.

Any help for tracking performance is appreciable.

Upvotes: 0

Views: 941

Answers (1)

Alex Ott
Alex Ott

Reputation: 87359

Statistics about performance for particular keyspace/table could be obtained via nodetool tablehistograms command (as described in documentation).

For generation of load against tables you can use cassandra-stress tool that comes together with Cassandra. It quite powerful, but requires writing of correct configuration file that mimics your tables. This blog post is quite helpful together with official documentation.

Upvotes: 1

Related Questions