influxdb中，series是一个很重要的概念，它是retentionPolicy、measurement、tag set雷同的汇合，蕴含了监控对象的元数据信息，series的数量=RP*measurement*tag set。
一般来讲，监控对象稳固后，series根本是固定的；influxdb将series放在内存作为索引，放慢了数据查问，这使得series的数量不能太大，否则influxdb内存会被撑爆，默认单个database内series限度为<100W个。
// influxdb.conf
# The maximum series allowed per database before writes are dropped. This limit can prevent
# high cardinality issues at the database level. This limit can be disabled by setting it to
# 0.
# max-series-per-database = 1000000series汇合的例子：每一行代表一个series
| 序号 | retention policy | measuerment | tag set |
|---|---|---|---|
| 1 | autogen | cpu.used.percent | location=sh,node=node1001 |
| 2 | autogen | cpu.used.percent | location=bj,node=node3001 |
| 3 | autogen | cpu.used.percent | location=sz,node=5001 |
查问series信息
查问所有的series
# influx -execute 'show series on opsultra'
统计所有的series数量
# influx -execute 'show series on opsultra' |wc -l
将series导出到csv
# influx -execute 'show series on opsultra' -format 'csv' > /tmp/series.csv查问series cardinality
cardinality反馈了series的维度，即不同的series的数量：
查问series的维度
# influx -execute 'show series cardinality on opsultra'
将series的维度导出到csv: 按measurement进行cardinality进行统计
# influx -execute 'show series exact cardinality on opsultra' -format 'csv' > /tmp/series.csv参考：
https://jasper-zhang1.gitbook…
https://docs.influxdata.com/i…
发表回复