关于influxdb:InfluxDB-Series解析

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 = 1000000

series汇合的例子：每一行代表一个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...