How to drop a series when running out of memory

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?


I got it to work. I just had to keep stopping my influxd and restarting. Each time it had less memory usage than the last time. Eventually it worked. If there’s a better way, I’d still be interested in hearing it.