How to delete data from InfluxDB ?

InfluxDB is one of the most popular Timeseries data stores. It’s useful for recording system metrics, events, and performing analytics.As the data grows in the InfluxDB , we might need to delete old data which is irrelevant . In this article we will explain how to delete data from InfluxDB

First we will connect the InfluxDB server using “influx” client

Now let us see the data in the Series “mysql_value”

We will delete series data which is older than 1000s

You can see that above command deleted all data in the series “mysql_value” .

How to delete the data from InfluxDB referencing other columns?

Let us see how to delete the data for a particular host

 

In the above example we deleted all series data where “host” matches “test.test.com” 

SUMMARY

In this article we explained how to delete data from influxdb using “where” clause. 

As always,please drop us a note if you have any questions or feedback using our comment form below.

Always Happy to Help ????

2 thoughts on “How to delete data from InfluxDB ?

  • February 19, 2017 at 8:49 am
    Permalink

    I’m collected several series data and will prefer to run something like:

    “delete from * where time > 2592000s;”.

    Reply
  • November 2, 2017 at 7:53 am
    Permalink

    Great article, thank you.

    How do I delete all data from all series that are older than a month (2592000s)?

    I have a CollectD instance writing metrics to an InfluxDB database and it has grown so large there’s literally no space left on the device.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *