title: How to get the Cassandra Table/Columnfamily size in MB
body: <p>I want to design my cluster and want to set proper size of key_cache and row_cache
  depending on the size of the tables/columnfamilies.
  Similar to mysql, do we have something like this in Cassandra/CQL?</p>
  
  <pre><code>SELECT table_name AS "Tables", 
  round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
  FROM information_schema.TABLES 
  WHERE table_schema = "$DB_NAME";
  </code></pre>
  
  <p>Or any other way to look for the data-size and indexes' size separately.</p>
  
  <p>Or what configuration of each node would be needed to put my table completely in the memory
  without considering any replication factor.</p>