I have a measurement with high cardinality and it’s causing too much memory usage. I’ve fixed the problem that is causing that and copied the cleaned up data to a new measurement. Now I want to drop the old measurement or the series in that measurement.
When I run “drop series from <measurement_name>” my influxd process starts using all of the memory on the hardware and the entire machine slows to a crawl. It’s been running for over 2 hours now. I’ve been trying multiple methods and search terms to figure out how to do this better.
Is there a better way to drop the data that won’t kill my machine by using all of the memory?