# Instaclustr Open Sources Cassandra sstable Analysis Tools

[Blog](/blog/)&gt;[Technology](/blog/category/technical/)&gt;Instaclustr Open Sources Cassandra sstable Analysis Tools 

Instaclustr Open Sources Cassandra sstable Analysis Tools
=========================================================

February 13, 2017 | By [ Ben Slater](https://www.instaclustr.com/blog/author/bens/)

 

 

 

 



   [ ](https://x.com/intent/tweet?text=Instaclustr%20Open%20Sources%20Cassandra%20sstable%20Analysis%20Tools&url=https://www.instaclustr.com/blog/instaclustr-open-sources-cassandra-sstable-analysis-tools/) [ ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.instaclustr.com/blog/instaclustr-open-sources-cassandra-sstable-analysis-tools/&title=&summary=Instaclustr%20Open%20Sources%20Cassandra%20sstable%20Analysis%20Tools&source=) 

At Instaclustr we spend a lot of time managing Cassandra clusters – we have team of engineers that 24×7 do nothing but manage Cassandra clusters. Big clusters, tiny clusters, clusters with awesome data models and clusters with less awesome data models – we manage them all.

Over time, we’ve developed a lot of tricks and tools to help us in this job. We’re happy to announce that, as part of our commitment to the [Apache Cassandra](https://www.instaclustr.com/platform/managed-apache-cassandra/) open source community, we’re making our most generally useful tools available for open use.

The tools (that we’ve imaginatively called ic-tools) supplement the information available from the nodetool utility that is part of core [Apache Cassandra](https://www.instaclustr.com/platform/managed-apache-cassandra/). Whereas nodetool tends to report based on summary statistics maintained as Cassandra services operate, ic-tools directly reads Cassandra’s data files when executed. This allows reporting of more detailed and accurate statistics.

We’ve found the information available from these tools to be invaluable in answering questions to help diagnose Cassandra issues or just better understand what Cassandra is doing with your data. The information available from the tools is pretty broad. Some highlights that will resonate with many Cassandra users include:

- Partition keys of the largest partitions by data size, number of columns and sstables spanned
- Information about data age (timespan) of data in sstables
- Tombstone information including partition keys of partitions with the most tombstones and calculation of potentially reclaimable space if/when tombstones are purged

This is just a highlights list of key data. See the [help page](https://instaclustr.zendesk.com/hc/en-us/articles/235656328) and examples below for a more complete list.

The tools are available on a supported basis for our enterprise support customers and on an unsupported basis for the general community (although we’ll probably answer questions on the C\* user email list). For users of [Instaclustr’s Managed Service](https://www.instaclustr.com/platform/), our Technical Operations team will run these as needed when working with you to help diagnose issues.

The source code is published on our [GitHub](https://github.com/instaclustr/cassandra-sstable-tools). We’re more than happy to take pull requests and other suggestions for improvements. We’ll also be talking to the C\* project to see if any of this code makes sense in the core project.

We hope these tools will be as useful for the rest of the Cassandra community as we’ve found them in our work. Let us know in the comments if you have any feedback.

![Cassandra sstable analysis tools - 1](https://www.instaclustr.com/wp-content/uploads/2021/10/ic.jpg)

![Cassandra sstable analysis tools - 2](https://www.instaclustr.com/wp-content/uploads/2021/10/ic2.jpg)

![Cassandra sstable analysis tools - 3](https://www.instaclustr.com/wp-content/uploads/2021/10/ic3.jpg)

![Cassandra sstable analysis tools - 4](https://www.instaclustr.com/wp-content/uploads/2021/10/ic4.jpg)

![Cassandra sstable analysis tools - 5](https://www.instaclustr.com/wp-content/uploads/2021/10/ic5.jpg)

[Contact Instaclustr](mailto:sales@instaclustr.com) for any enquiries or [sign up for a free trial](https://console.instaclustr.com/user/signup).

 

### About the author

**[Ben Slater](https://www.instaclustr.com/blog/author/bens/)** | Chief Product Officer

Chief Product Officer, charged with steering Instaclustr’s development roadmap and overseeing the product engineering, production support, open source, and consulting teams.

 

 [ Add Instaclustr as a preferred source on Google ](https://google.com/preferences/source?q=instaclustr.com)



 

 ![mail icon]()#### Get the latest articles for open sourceIn your inbox

 <a class="btn btn-primary btn-popup text-dark" href="">Sign up now</a> 

 

 

 

  ### Related content

 [ Zero Downtime Migration to Instaclustr 

 

 Yes, we can migrate existing Cassandra clusters to Instaclustr without any downtime. Here's what to expect from the process... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/zero-downtime-migration-to-instaclustr/) 

 [ Workflow Comparison: Uber Cadence vs Netflix Conductor 

 

 When choosing what’s right for your company’s opensource workflow needs it is important to know the difference and similarities ... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/workflow-comparison-uber-cadence-vs-netflix-conductor/) 

 [ Will Your Cassandra Database Project Succeed?: The New Stack 

 

 Open source Apache Cassandra® continues to stand out as an enterprise-proven solution for organizations seeking high availability... 

 

 

 

 

 

 

 ](https://www.instaclustr.com/blog/will-your-cassandra-database-project-succeed-the-new-stack/) 

 

  <a class="close-modal" href="">×</a>Sign upto ourNewsletter
-----------------------
