One more question, i had to enter "bind" after changing the database, now "list series" gives me:
I can select all events by running:
> select * from "log/events"
Is there also a way wo delete entries like
> delete from "log/events"
Could not handle the command. type 'help' to get a help menu
I was playing around with influx-cli because i am looking for a possibility to delete date, since database size is 9 GB. I read something about retention, but i found it in v0.9. When are entries deleted from database? I don't know what means the following command, but does it mean that after 7 days old entries are overwritten?
> list shardspaces
Database Name Regex Retention Duration RF Split
k8s default /.*/ inf 7d 1 1
Gesendet: Mittwoch, 11. November 2015 um 12:26 Uhr
Von: "Marian Ignev" <m ignev gmail com>
An: MA2412 gmx de
Cc: "Openshift Maillist" <users lists openshift redhat com>
Betreff: Re: InfluxDB
Login to the UI of the InfluxDB and then write a query:
this will return all the series for the certain database. After that choose the specific series and write the following query:
select * from series limit 1
This will return the schema of the series.
If you want to delete some old data you can write the following query:
delete from series where time < now() - 7d
Hope this will help.