-
Notifications
You must be signed in to change notification settings - Fork 0
/
capacity_db.sql
44 lines (37 loc) · 1.15 KB
/
capacity_db.sql
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
32
33
34
35
36
37
38
39
40
41
42
43
CREATE DATABASE capacity;
GRANT ALL ON capacity.* TO 'capacity'@'%' IDENTIFIED BY 'planning';
USE capacity;
CREATE TABLE benchmarks (
cluster_name varchar(30) NOT NULL default '',
max_rps float(10,1) default NULL,
last_updated datetime NOT NULL,
ip_addr int(10) unsigned NOT NULL,
PRIMARY KEY (cluster_name)
);
CREATE TABLE clusters (
cluster_name varchar(30) NOT NULL default '',
description varchar(100) NOT NULL default '',
sort_order int(10) unsigned default NULL,
last_updated datetime NOT NULL,
PRIMARY KEY (cluster_name),
KEY sort_order (sort_order)
);
CREATE TABLE exceptions (
cluster_name varchar(30) NOT NULL default '',
rps float(10,1) default NULL,
memory float(5,1) default NULL,
disk float(5,1) default NULL,
last_updated datetime NOT NULL,
ip_addr int(10) unsigned NOT NULL,
PRIMARY KEY (cluster_name)
);
CREATE TABLE history (
post_date date NOT NULL,
cluster_name varchar(30) NOT NULL default '',
hosts int(10) unsigned default NULL,
rps float(10,1) default NULL,
cpu float(5,1) default NULL,
memory float(5,1) default NULL,
disk float(5,1) default NULL,
PRIMARY KEY (post_date,cluster_name)
);