Shrink cassandra DB-size

Solved161 views
1
0 Comments

Dear Dojo

At one customer we have very small installation with only a few devices.
We are not interested in historical alarm details, but we are facing a cassandra backup of almost 10GB.

A deeper investigation shows a cassandra directory of almost 7 GB:

A DataMiner backup take a lot of time and we would like to shrink the database to the really needed alarms.

Can you explain, what is stored in timetrace, and how to delete old, not nessecary entries?

I appreciate your support.

Joerg Stumpf [DevOps Advocate] Selected answer as best 17th July 2024

1 Answer

1
2.53K 1 Comment

Hi Joerg,

The timetrace table stores historical alarms : DataMiner general database - NoSQL Database - Cassandra | DataMiner Docs.

If you do not need historical alarms, you can truncate this table - TRUNCATE | CQL for Cassandra 3.0 (datastax.com).

Joerg Stumpf [DevOps Advocate] Selected answer as best 17th July 2024
Joerg Stumpf [DevOps Advocate] commented

Thanks a lot Arunkrishna for that valuable Information.
This works perfect !!!
You are viewing 1 out of 1 answers, click here to view all answers.