How to drop host records in influxdb
Reference link https://community.influxdata.com/t/commad-to-delete-a-particular-series-from-influxdb/5600/2
This is simply what I’ve run and it seems to have worked:
DROP SERIES FROM "measurement" WHERE "tag" = 'value'
Example for delete host=H13-92
influx -database grafana -host localhost -port 8086 -username root -password $PW
show measurements # for list all items released value
name: measurements
name
cpu
disk
diskio
kernel
mem
net
processes
swap
system
drop series from cpu where host = ‘H13-92’
drop series from disk where host = ‘H13-92’
……
show series where host = ‘H13-92’ # for ensure all item released host = H13-92 have clear up