[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Aw: Re: InfluxDB



Hi Marian!
Thanks for your help! I now have installed "influx-cli" on my server and it looks ok for me. if i run "list db" i get:
k8s
grafana
 
Now if i open a database with "\db grafana" or "\db k8s" and i run "list series" i get no output, so no series are found.
 
>conn
Host        : influxdb-monitoring-4vadz:8086
User        : root
Pass        : root
Db          : grafana
secure      : false
udp         : false
compression : ?
Client      : &{<nil> %!s(func(*http.Request, []*http.Request) error=<nil>) <nil> 0}
 
>list servers
## id 1
                 isLeader true
                     isUp false
  leaderRaftConnectString http://influxdb-monitoring-4vadz:8090
           leaderRaftName 2357728288914ccf
    protobufConnectString influxdb-monitoring-4vadz:8099
     raftConnectionString http://influxdb-monitoring-4vadz:8090
                 raftName 2357728288914ccf
 
 
The "isUp false" is not clear for me. I can ping the Server "influxdb-monitoring-4vadz" and i cann connect to the port 8090 with telnet.
 
My configuration file for influx-cli is:
 
host = "influxdb-monitoring-4vadz"
port = 8086
user = "root"
pass = "root"
db = "grafana"
asyncCapacity = 100  # in datapoints
asyncMaxWait = 1000  # in ms
 
Why is the port in "list servers" 8090? Shouldn't it be 8086?
 
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
Hi,
 
Login to the UI of the InfluxDB and then write a query:
 
list series
 
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.
 
Поздрави,
Мариан Игнев

---
www: http://m.ignev.net/
twitter: @mignev
 
 
 
2015-11-11 11:53 GMT+02:00 <MA2412 gmx de>:
Hello!
I am running openshift 1.0.6 and deployed Cluster Metrics with InfluxDB v8.8. The database size is 6.8GB, so i tried to delete some data, since documentation for v8.8 is very rare, i have no idea how database schema looks like an so i fail to write the corresponding "DELETE" statemets. Can someone give me a hint how to query/get the database schema? Does v8.8 support retention policies like v9 to automatically limit the database size?
 

_______________________________________________
users mailing list
users lists openshift redhat com
http://lists.openshift.redhat.com/openshiftmm/listinfo/users
 
 
 

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]