时间序列数据库 - Time Series Database (TSDB)

by
noyesno
at

时间序列数据

set props [dict create host server-abc type web]
set values [dict create idle 34 load 13 uptime 12345]
set record [list $timestamp $props $values]

关系型数据库

CREATE TABLE tsdb_records (
   -- 时间, 用于主键
   time PRIMARY KEY,

   -- props 用于索引
   host TEXT,
   type TEXT,

   -- values 具体的数值
   idle   NUMERIC,
   load   INTEGER,
   uptime NUMERIC
);

CREATE INDEX tsdb_index_time  ON tsdb_records (time);
CREATE INDEX tsdb_index_props ON tsdb_records (host, type);

RRDtool

InfluxDB

  • timestamp + tag-set + field-set
  • Support multiple fields
  • No limitation on number of tags

InfluxDB Line Protocol

cpu,host=serverA,region=uswest idle=23,user=42,system=12 1464623548s