prometheus-data-visualization/create.sql at master · CoderChang65535/prometheus-data-visualization · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
CREATE SCHEMA `prom-vs` DEFAULT CHARACTER SET utf8 ;

CREATE TABLE `prom-vs`.`CPU` (
  `queryID` varchar(45) NOT NULL,
  `time` datetime NOT NULL,
  `value` varchar(45) NOT NULL,
  `node` varchar(45) NOT NULL,
  PRIMARY KEY (`time`,`node`,`queryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `prom-vs`.`BasicInfo` (
  `queryID` VARCHAR(45) NOT NULL,
  `time` VARCHAR(45) NOT NULL,
  `type` VARCHAR(45) NOT NULL,
  `node` VARCHAR(45) NOT NULL,
  `value` VARCHAR(45) NULL,
  PRIMARY KEY (`queryID`, `time`, `type`, `node`));

CREATE TABLE `prom-vs`.`Memory` (
  `queryID` VARCHAR(45) NOT NULL,
  `time` VARCHAR(45) NOT NULL,
  `node` VARCHAR(45) NOT NULL,
  `value` VARCHAR(1023) NULL,
  PRIMARY KEY (`queryID`, `time`, `node`));

CREATE TABLE `prom-vs`.`TCP` (
  `queryID` VARCHAR(45) NOT NULL,
  `time` VARCHAR(45) NOT NULL,
  `node` VARCHAR(45) NOT NULL,
  `value` VARCHAR(1023) NULL,
  PRIMARY KEY (`queryID`, `time`, `node`));