InfluxDB: InfluxDB http api Query
In the last article on InfluxDB: InfluxDB's InfluxDB http api write operation, we introduced the process of using InfluxDB's http api to write data, this article introduces how to use InfluxDB's http api to query data. For more details about Influx
Use python to operate InfluxDB and python to operate influxdb
Environment: CentOS6.5 _ x64InfluxDB version: 1.1.0Python: 2.6Preparations
Start the server
Run the following command:
service influxdb start
Example:
[root@localhost ~]# service influxdb startStarting influxdb
Tags: auth influxdb running his icon doc should group by ACKGrafana comes with a feature-rich data source plug-in influxdb. Supports rich query Editor, annotations, and templating (template) queries. Adding data sources (Adding the source)
Click the top Grafana icon to open the side menu.
In the Dashboards side menu under links, you should find a link called data sources.
Click on the but
Influxdb and traditional database in the concept of a lot of different, this article will give you some basic concepts in the INFLUXDB, more influxdb detailed tutorial see: INFLUXDB Series of Learning Tutorials DirectoryINFLUXDB Technology Group: 580487672 (click to join)Comparison with nouns in traditional database
InfluxDB is an open source distributed timing, event, and metrics database.Written in the Go language without external dependencies. Its design goal is to achieve distributed and horizontal scaling expansion.It has three main features:1. Time series (timeseries): You can use time-related functions (such as Max, Min, sum, etc.)2. Metrics (Metric): You can calculate large amounts of data in real time3. Eevents (Event): It supports arbitrary event dataCh
1) count () functionReturns the number of non-null values in an (field) field.Grammar:SELECT COUNT (Example:>select COUNT (water_level) from H2o_feetname:h2o_feet--------------time count1970-01-01t00:0 0:00z 15258Description Water_level This field has a total of 15,258 data in the H2o_feet table.Note: The function in Influxdb will default to epoch 0 (1970-01-01t00:00:00z) as time if no time is specified.You can add a time condition to the where, as fo
Tags: flush table tor months Insert data lookup function max two pointsThis article is part of the series Influxdb series, which includes the following 15 parts:
influxdb to learn Influxdb installation and introduction
influxdb basic operation of learning Influxd
1) count () functionReturns the number of non-null values in an (field) field.Grammar:SELECT COUNT (Example:>select COUNT (water_level) from H2o_feetname:h2o_feet--------------time count1970-01-01t00:0 0:00z 15258Description Water_level This field has a total of 15,258 data in the H2o_feet table.Note: If the function in Influxdb does not have a specified time, it will default to epoch 0 ( 1970-01-01T00:00:00Z ) as the time.You can add a time condition
is: (2.116-2.064/(6m/12m)Calculates the rate of change for the maximum value every 12 minutes> SELECT derivative (MAX (water_level)) from H2o_feet WHERE location = ' Santa_monica ' and Time >= ' 2015-08-18t00:00:00Z ' and Time This function is very versatile, very complex, more detailed explanation of this function please crossing: https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#derivative2) difference () functionEffect: Returns
Comparison with nouns in traditional database
Nouns in the nfluxdb
Concepts in a traditional database
database
database
measurement
table in the database
Points
A row of data inside the table
Second, the unique concept of INFLUXDB1) database--database, this database concept with traditional database.2) measurement--data Sheet, in Influxdb, measurement is the role
integer or float64.A percent value is an integer or floating-point number between 100 and 0, including 100.Grammar:SELECT percentile (Example:> SELECT percentile (water_level,5), location from H2o_feetname:h2o_feet--------------time Percenti Le location2015-08-28t12:06:00z 1.122 Santa_monicais to apply the Water_level field to a different location for a percentage, and then take the fifth bit of data.This article is from the "DBSpace" blog, so be sure to keep this source http://dbspace.blog.51c
Tags: readme.md open zhang Pat Hot add bar version-sharedThis is my previous INFLUXDB installation and configuration notes, recorded here, it is also convenient for me to check later. Environment: centos6.5_x64 Influxdb version: 1.1.0First, install 1, binary installationHere is an example of centos6.5 installation: wget https://dl.influxdata.com/influxdb/release
Build a modern monitoring system using Grafana, collectd, and InfluxDB
To create a beautiful real-time monitoring system like New Relic, we only need the three InfluxDB, collectd, and Grafana tools. The relationship between these three tools is as follows:
Collect data-> store data (InfluxDB)-> display data (Grafana ).
Inf
This is a creation in
Article, where the information may have evolved or changed.
Objective
Influxdb is an open-source timing database based on Golang, with no additional dependencies, for recording metrics, events, and data analysis. This article discusses the INFLUXDB version above 1.2.0 . This article only discusses INFLUXDB data storage applications in monito
In the previous blog post, we introduced the key features, data reading and writing, and application scenarios of the necessary-influxdb for Internet-level monitoring systems:The influxdb of the time-series database of Internet-level monitoring systemIn this article, we introduce the construction of the INFLUXDB database cluster, and share the pits we encounter w
Ubuntu under Cadvisor+influxdb+grafana+supervisord Monitor host and Docker containers (running on the host)Applies to the class Ubuntu system. AMD64.1. INFLUXDB: (Consider converting Influxdb to Prometheus later)Https://influxdb.com/docs/v0.8/introduction/installation.html#ubuntu-debian(You can only choose the way the Deb is installed.) There's no way to compile
Tags: docker docker monitor Cadvisor influxdb Grafana1. ConceptCadvisor: For data acquisitionInfluxDB: For data storageGrafana: For data presentation1.1 Cadvisor
It is a monitoring tool that Google uses to monitor the resource information of a single node. Cadvisor provides a glance at a single node multi-container resource monitoring function. Google's kubernetes also by default as a single-node resource monitoring tool, the lack of provinci
Use cAdvisor + InfluxDB + Grafana to configure Docker monitoring and cadvisorinfluxdb
Configure the Docker monitoring system, collect data (cAdvisor)-> store data (InfluxDB)-> display data (Grafana)InfluxDB
A series of InfluxDB learning articles. You can view articles related to English blogs and Linux universities.1.
Tags: expired redis monitor file Max Files Recovery server label missingINFLUXDB Basic Concepts1. Data formatIn InfluxDB, we can take a rough look at the data that will be deposited as a virtual key and its corresponding value (field value). The format is as follows:
1
cpu_usage,host=server01,region=us-west value=0.641434055562000000000
The virtual key consists of the following parts: database, retention policy, measure
This is an era of big data outbreaks. In the face of the torrent of information, the emergence of diversified data, we in the acquisition, storage, transmission, understanding, analysis, application, maintenance of big data, there is no doubt that a convenient information exchange channel, in order to quickly, effectively, accurately understand and harness the process. This article will show you how to make the data easy to present through the practice of the Time series Database (
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.