summaryrefslogtreecommitdiff
path: root/opendc/opendc-experiments-sc20/schema.sql
diff options
context:
space:
mode:
authorGeorgios Andreadis <g.andreadis@student.tudelft.nl>2020-05-17 22:00:20 +0200
committerGeorgios Andreadis <g.andreadis@student.tudelft.nl>2020-05-17 22:00:20 +0200
commitc78d99c198e48dfa1b9f0f22f936ebc9457e5a5b (patch)
tree633cfa8c2331c34c3572ee8e404ff80567010d5a /opendc/opendc-experiments-sc20/schema.sql
parent210ca9d4b82cda82d0651e539c38d36eb61aec1e (diff)
parent2211cc2af7fced34921055e8d5fb5516457b4cc0 (diff)
Merge branch 'feat/database-metrics' into '2.x'
Implement experiment runner in Kotlin Closes #63 See merge request opendc/opendc-simulator!66
Diffstat (limited to 'opendc/opendc-experiments-sc20/schema.sql')
-rw-r--r--opendc/opendc-experiments-sc20/schema.sql22
1 files changed, 0 insertions, 22 deletions
diff --git a/opendc/opendc-experiments-sc20/schema.sql b/opendc/opendc-experiments-sc20/schema.sql
deleted file mode 100644
index 51990a75..00000000
--- a/opendc/opendc-experiments-sc20/schema.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-DROP TABLE IF EXISTS host_reports;
-CREATE TABLE host_reports (
- id BIGSERIAL PRIMARY KEY NOT NULL,
- experiment_id BIGINT NOT NULL,
- time BIGINT NOT NULL,
- duration BIGINT NOT NULL,
- requested_burst BIGINT NOT NULL,
- granted_burst BIGINT NOT NULL,
- overcommissioned_burst BIGINT NOT NULL,
- interfered_burst BIGINT NOT NULL,
- cpu_usage DOUBLE PRECISION NOT NULL,
- cpu_demand DOUBLE PRECISION NOT NULL,
- image_count INTEGER NOT NULL,
- server TEXT NOT NULL,
- host_state TEXT NOT NULL,
- host_usage DOUBLE PRECISION NOT NULL,
- power_draw DOUBLE PRECISION NOT NULL,
- total_submitted_vms BIGINT NOT NULL,
- total_queued_vms BIGINT NOT NULL,
- total_running_vms BIGINT NOT NULL,
- total_finished_vms BIGINT NOT NULL
-);