something doesn't make sense here - MySQL/InnoDB does put tables into files, but partitions get separate file. MyRocks has a collection of files per each colum

something doesn't make sense here - MySQL/InnoDB does put tables into files, but partitions get separate file. MyRocks has a collection of files per each column family, and when you drop data it can quickly expunge files that don't contain data for other tables/partitions - and trigger compaction on neighbors, if needed.