Originally from the User Slack
@Matheus_Salvia: Hi, nodetool status
is reporting around 3.3TB of data in a node, but df -h
shows around 5TB used in the disk. I suspect there are some tables that I deleted last year that didn’t get actually removed. how can I figure this out?
@Botond_Dénes: You can list all the tables scylla knows about by querying system_schema.tables
, then compare this with what you have on disk.
In data directory, we have the following structure:
<data-dir>/${keyspace-name}/${table-name}-${table-id}
Look for orphan directories, they may still hold data in the snapshot
subdir, we don’t remove snapshots when removing a table.
Maybe nodetool listsnapshots
is also able to list these.
@Matheus_Salvia: thanks