From fbf4ca99c9132b973025d84df0366d1cdaade686 Mon Sep 17 00:00:00 2001 From: "user.email" Date: Fri, 4 Oct 2019 20:20:40 +0000 Subject: [PATCH] telemetry/server/tables.txt: add device_report table Signed-off-by: Sage Weil --- src/telemetry/tables.txt | 60 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 60 insertions(+) create mode 100644 src/telemetry/tables.txt diff --git a/src/telemetry/tables.txt b/src/telemetry/tables.txt new file mode 100644 index 00000000000..bcd31cbb221 --- /dev/null +++ b/src/telemetry/tables.txt @@ -0,0 +1,60 @@ + +CREATE TABLE report ( + cluster_id VARCHAR(50), + report_stamp TIMESTAMP, + report TEXT, + PRIMARY KEY(cluster_id, report_stamp) +); + +CREATE TABLE device_report ( + device_id VARCHAR(50), + report_stamp TIMESTAMP, + report TEXT, + PRIMARY KEY(device_id, report_stamp) +); + +CREATE TABLE cluster ( + cluster_id VARCHAR(50) PRIMARY KEY, + latest_report_stamp TIMESTAMP, + + num_mon INT, + num_osd INT, + num_mds INT, + num_mgr INT, + num_rgw INT, + + num_pools INT, + num_pgs BIGINT, + total_bytes BIGINT, + total_used_bytes BIGINT +); + +CREATE TABLE cluster_version ( + cluster_id VARCHAR(50), + entity_type CHAR(64), + version CHAR(128), + + num_daemons INT, + + PRIMARY KEY (cluster_id, entity_type, version) +); + +CREATE TABLE crash ( + crash_id VARCHAR(128) PRIMARY KEY, + cluster_id VARCHAR(50), + raw_report TEXT, + + timestamp TIMESTAMP, + entity_name CHAR(64), + + version VARCHAR(64), + + stack_sig VARCHAR(64), + stack_weak_sig VARCHAR(64), + stack TEXT +); + + +drop table cluster; +drop table cluster_version; +drop table crash; -- 2.39.5