CREATE TABLE IF NOT EXISTS instance(
name varchar(50) primary key,
CPU varchar(50) ,
vCPUs int ,
memory_type varchar(50) default 'ddl3' ,
memory_size varchar(20) ,
disk_num int ,
disk_size varchar(50) ,
is_nvme varchar(50) ,
bw_read varchar(50) ,
bw_write varchar(50) ,
bw_rw varchar(50) ,
iops_read varchar(50) ,
iops_write varchar(50) ,
iops_rw varchar(50) )
CHARSET=utf8;
CREATE TABLE `cluster` (
`cluster_key` varchar(50) NOT NULL,
`master_os` varchar(50) DEFAULT NULL,
`master_num` int DEFAULT NULL,
`master_instance_name` varchar(50) DEFAULT NULL,
`master_EBSs_num` int DEFAULT NULL,
`master_EBSs_size` int DEFAULT NULL,
`workers_os` varchar(50) DEFAULT NULL,
`workers_num` int DEFAULT NULL,
`workers_instance_name` varchar(100) DEFAULT NULL,
`workers_EBSs_num` int DEFAULT NULL,
`workers_EBSs_size` int DEFAULT NULL,
`UFS_name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`cluster_key`)
)
CREATE TABLE IF NOT EXISTS tpc_performance(
test_key int primary key auto_increment,
cluster_key varchar(50) unique,
erdma_used enum('Y','N') ,
spark_version varchar(50),
hadoop_version varchar(50),
spark_conf varchar(300),
hadoop_conf varchar(100),
tpc_ds_data_size int,
tpc_ds_gen_time varchar(50),
ds_gen_grafana varchar(200),
ds_gen_url varchar(200),
tpc_ds_sql_time varchar(50),
ds_sql_grafana varchar(200),
ds_sql_url varchar(200),
single_driver_log_OSS_path varchar(100),
single_SHS_log_OSS_path varchar(100),
mul_tpc_ds_data_size int,
mul_tpc_ds_gen_time decimal(5,2),
mul_tpc_ds_gen_metrics_url varchar(200),
mul_tpc_ds_sql_time decimal(5,2),
mul_tpc_ds_sql_metrics_url varchar(200),
mul_driver_log_OSS_path varchar(100),
mul_SHS_log_OSS_path varchar(100),
tpcx_hs_data_size int,
tpcx_hs_gen_time varchar(50),
hs_gen_grafana varchar(200),
hs_gen_url varchar(200),
tpcx_hs_sort_time varchar(50),
hs_sort_grafana varchar(200),
hs_sort_url varchar(200),
tpcx_hs_validate_time varchar(50),
hs_validate_grafana varchar(200),
hs_validate_url varchar(200),
tpcx_hs_driver_log_OSS_path varchar(100),
tpcx_hs_SHS_log_OSS_path varchar(100),
tpcds_total_time varchar(10),
tpcxhs_total_time varchar(10),
HSph varchar(10),
data_v varchar(10)
)CHARSET=utf8;
