Integrating Grafana into a web app
A little background, I have been working with BCI (brain computer interface) and multi channel EEG to monitor brain activity. When the user starts a session with the BCI cap on, the raw data streaming from each channel is … Read the rest “Integrating Grafana into a web app”
How to make a choice between OpenTSDB and InfluxDB or other TSDS? [closed]
They both are open source distributed time series databases, OpenTSDB for metrics, InfluxDB for metrics and events with no external dependencies, on the other OpenTSDB based on HBase.
Any other comparation between … Read the rest “How to make a choice between OpenTSDB and InfluxDB or other TSDS? [closed]”
select from InfluxDB where value is null
If my data (conceptually) is:
# a b c
1 1 1
2 1 1 0
3 1 0 1
Then in legacy SQL language, the statement would be:
select * from table where b is null… Read the rest “select from InfluxDB where value is null”
InfluxDB storage size on disk
All I want is simply to know how much space my InfluxDB database takes on my HDD. The stats() command gives me dozens of numbers but I don’t know which one shows what I want.
… Read the rest “InfluxDB storage size on disk”
How to install InfluxDB in Windows
I am new to InfluxDB. I could not find any details about installing InfluxDB on Windows. Is there any way to install it on a Windows machine or do I need to use a Linux server for development purposes?
… Read the rest “How to install InfluxDB in Windows”
Export data from InfluxDB
Is there a way (plugin or tool) to export the data from the database (or database itself) ? I’m looking for this feature as I need to migrate a DB from present host to another one.
… Read the rest “Export data from InfluxDB”
In Influxdb, How to delete all measurements?
I know DROP MEASUREMENT measurement_name used to drop single measurement. How to delete all measurements at once ?
Theres no way to drop all of the measurements directly, but the query below will achieve the
… Read the rest “In Influxdb, How to delete all measurements?”
Can you delete data from influxdb?
How do you delete data from influxdb?
The documentation shows it should be as simple as:
delete from foo where time < now() -1h
For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause that doesn't reference time"
select * from bootstrap where duration > 1000 and time 14041409940s and time < now()
I want to delete these 5 entries whos duration > 1000 seconds
This should be a valid sql statement, yet it fails… Read the rest “Can you delete data from influxdb?”
How to format time in influxdb select query
I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?
You can select RFC 3339 formatting
… Read the rest “How to format time in influxdb select query”
Usecases: InfluxDB vs. Prometheus [closed]
Following the Prometheus webpage one main difference between Prometheus and InfluxDB is the usecase: while Prometheus stores time series only InfluxDB is better geared towards storing individual events. Since there was some major work done on the storage engine of … Read the rest “Usecases: InfluxDB vs. Prometheus [closed]”