Please rethink your use case. Create and delete tables concurrently often lead to schema disagreement. Even doing so on a single node sequentially will lead to a large number of tombstones in the system tables.

On 04/12/2023 19:55, Sébastien Rebecchi wrote:
Thank you Dipan.

Do you know if there is a good reason for Cassandra to let tables folder even when there is no snapshot?

I'm thinking of use cases where there is the need to create and delete small tables at a high rate. You could quickly end with more than 65K (limit of ext4) subdirectories in the KS directory, while 99.9.. % of them are residual of deleted tables.

That looks quite dirty from Cassandra to not clean its own "garbage" by itself, and quite dangerous for the end user to have to do it alone, don't you think so?

Thanks,

Sébastien.

Le lun. 4 déc. 2023, 11:28, Dipan Shah <dipan....@hotmail.com> a écrit :

    Hello Sebastien,

    There are no inbuilt tools that will automatically remove folders
    of deleted tables.

    Thanks,

    Dipan Shah

    ------------------------------------------------------------------------
    *From:* Sébastien Rebecchi <srebec...@kameleoon.com>
    *Sent:* 04 December 2023 13:54
    *To:* user@cassandra.apache.org <user@cassandra.apache.org>
    *Subject:* Remove folders of deleted tables
    Hello,

    When we delete a table with Cassandra, it lets the folder of that
    table on file system, even if there is no snapshot (auto snapshots
    disabled).
    So we end with the empty folder {data folder}/{keyspace
    name}/{table name-table id} containing only 1  subfolder, backups,
    which is itself empty.
    Is there a way to automatically remove folders of deleted tables?

    Sébastien.

Reply via email to