How to know the size of a keyspace and column family in Cassandra?

cassandra nodetool
JavaRookie picture JavaRookie · Nov 19, 2014 · Viewed 30.8k times · Source

Recently I've started working on Grails integration with Cassandra using the Java driver for cassandra(cassandra-driver-core-2.0.2). So I was curious to know how we can find out how much size our table is taking to store the data in cassandra DB.

I have created a keyspace with name Customkeyspace and a column family called Movie in it. So I was curious to know which tool/Command I have to use to know the size of the keyspace/Column family ?

Answer

Erick Ramirez picture Erick Ramirez · Nov 19, 2014

To get statistics regarding column families in Cassandra, you can simply run the command:

nodetool cfstats

It reports statistics about tables which include the live data size as well as on disk.

The documentation about this utility for Cassandra 2.1 is available here.

Related questions

how do i know if nodetool repair is finished

I have a 2 node apache cassandra (2.0.3) cluster with rep factor of 1. I change rep factor to 2 using the following command in cqlsh ALTER KEYSPACE "mykeyspace" WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 2 }; I then tried to run recommended "nodetool repair" after …

Read More
How to get the replication factor of C* cluster?

I cant find it in cassandra.yaml, maybe nodetool can get me the configured replication factor of my cluster? What is the default value of the replication factor?

Read More
cassandra nodetool : Failed to connect to '127.0.0.1:7199'

i installed cassandra 3.11.3-1 on centos7 & vmware i didn't have error while installing cassandra. i started cassandra and faced this logs. [root@localhost ~]# service cassandra start Starting cassandra (via systemctl): [ OK ] [root@localhost ~]# systemctl status cassandra cassandra.service - …

Read More