查看InfluxDB Quick Start的源代码
←
InfluxDB Quick Start
跳转到:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您刚才请求的操作只有这个用户组中的用户才能使用:
用户
您可以查看并复制此页面的源代码:
== Key Concepts == === Database === A logical container for users, retention policies, continuous queries, and time series data <br> === Measurement === The part of InfluxDB’s structure that describes the data stored in the associated fields. Measurements are strings. <br> === Tag === The key-value pair in InfluxDB’s data structure that records metadata. Tags are an optional part of InfluxDB’s data structure but they are useful for storing commonly-queried metadata; tags are indexed so queries on tags are performant. Query tip: Compare tags to fields; fields are not indexed. <br> ==== Tag Key ==== The key part of the key-value pair that makes up a tag. Tag keys are strings and they store metadata. Tag keys are indexed so queries on tag keys are performant. Query tip: Compare tag keys to field keys; field keys are not indexed. <br> ==== Tag Value ==== The value part of the key-value pair that makes up a tag. Tag values are strings and they store metadata. Tag values are indexed so queries on tag values are performant. <br> ==== Tag Set ==== The collection of tag keys and tag values on a point. <br> === Field === The key-value pair in InfluxDB’s data structure that records metadata and the actual data value. Fields are required in InfluxDB’s data structure and they are <b>not indexed</b> - queries on field values scan all points that match the specified time range and, as a result, are not performant relative to tags. Query tip: Compare fields to tags; <b>tags are indexed.</b> <br> ==== Field Key ==== The key part of the key-value pair that makes up a field. Field keys are strings and they store metadata. <br> ==== Field Value ==== The value part of the key-value pair that makes up a field. * Field values are the actual data; * They can be strings, floats, integers, or booleans. * It is always associated with a timestamp. Field values are not indexed - queries on field values scan all points that match the specified time range and, as a result, are not performant. Query tip: Compare field values to tag values; tag values are indexed. <br> ==== Field Set ==== The collection of field keys and field values on a point. <br> === Series === The collection of data in InfluxDB’s data structure that share a measurement, tag set, and retention policy. Note: The field set is not part of the series identification! <br><br> == influx shell == <source lang=bash> $ influx Connected to http://localhost:8086 version 1.2.x InfluxDB shell 1.2.x > show databases; name: databases name ---- _internal test telegraf > use telegraf; Using database telegraf > show measurements; name: measurements name ---- cpu disk diskio kernel mem processes swap system > </source> <br><br> == Creating a database == <source lang=bash> $ curl -i -XPOST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE mydb" $ influx Connected to http://localhost:8086 version 1.2.x InfluxDB shell 1.2.x > create database mydb; > show databases; name: databases name ---- _internal test telegraf mydb </source> <br><br> == Insert data == <source lang=bash> > USE mydb > INSERT cpu,host=serverA,region=us_west value=0.64 > select * from cpu; name: cpu time host region value ---- ---- ------ ----- 1494498034415516860 serverA us_west 0.64 </source> <b>Syntax:</b> <measurement>[,<tag-key>=<tag-value>...] <field-key>=<field-value>[,<field2-key>=<field2-value>...] [unix-nano-timestamp] <br><br> == Writing data == <source lang=bash> $ curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'cpu_load,host=server01,region=us-west value=0.64' </source> <br><br> == Queries == <source lang=bash> $ curl -GET 'http://raspberrypi:8086/query?pretty=true' \ --data-urlencode "db=mydb" --data-urlencode \ "q=SELECT \"value\" FROM \"cpu_load_short\" WHERE \"region\"='us-west'" \ | jq '.results[0].series' </source> <br><br> == Advanced Queries == <source lang=bash> > SELECT COUNT("water_level") FROM "h2o_feet" \ WHERE time >= '2015-08-19T00:00:00Z' \ AND time <= '2015-08-27T17:00:00Z' \ AND "location"='coyote_creek' GROUP BY time(3d) </source> * https://docs.influxdata.com/influxdb/v1.0/query_language/data_exploration/ <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br> <br><br>
返回到
InfluxDB Quick Start
。
个人工具
登录
名字空间
页面
讨论
变换
查看
阅读
查看源代码
查看历史
操作
搜索
导航
首页
社区专页
新闻动态
最近更改
随机页面
帮助
工具箱
链入页面
相关更改
特殊页面