当我们需要查看某个集群中相关的内表的指标时,方便直观预览。比如下面的指标:
库名、表名、类型、建表模型、注释、创建时间、数据量、总容量/MB、总容量/单位、分片数、总分区数、实际分区数(有数据)、空存储分区数(无数据)、空存储分区范围、总副本数、副本数、分桶数、总副本数平均差、总副本数标准差
触发扫描集群,sr-ma是我的集群名称
生成的报告如下所示
其他:
本工具需要依赖MYSQL配置表,修改连接方式在conn/MYSQL下:
CREATE TABLE
starrocks_information_connections
(
app
varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘集群名称(英文)’,
nickname
varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘别名’,
alias
varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘集群别名’,
feip
varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘集群连接地址(必填)F5,VIP,CLB,FE’,
user
varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘集群登录账号(必填) 建议是管理员角色的账号’,
password
varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘集群登录密码(必填)’,
feport
int NOT NULL DEFAULT ‘9030’ COMMENT ‘集群登录端口,默认9030’,
address
varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘MANAGER地址,如果填了MANAGER地址,那么将触发定时检查LICENSE是否过期(企业级)’,
expire
int DEFAULT ‘30’ COMMENT ‘LICENSE是否过期(企业级)过期提醒倒计时,单位day’,
status
int NOT NULL DEFAULT ‘0’ COMMENT ‘LICENSE是否过期(企业级)开关,0 off, 1 on’,
fe_log_path
varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘FE 日志目录’,
be_log_path
varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘BE 日志目录’,
java_udf_path
varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ‘BE 日志目录’,
updated_at
timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘StarRocks登录配置,manager地址,(定期检查license过期日期)’;