4x怎么查询租户近七天的合并时长
select TENANT_ID,STATUS,TOTAL_TABLET_COUNT,round(DATA_SIZE/1024/1024/1024/1024,2) as data_T,START_TIME,ESTIMATED_FINISH_TIME,TIMESTAMPDIFF(SECOND, START_TIME, ESTIMATED_FINISH_TIME)/60/60 AS use_h from GV$OB_COMPACTION_PROGRESS where type=‘MAJOR_MERGE’ order by data_T desc limit 10;
SELECT date_format(gmt_create,’%Y-%c-%d %T’) gmt_create, module, EVENT,name1, value1, name2, value2,name3,value3 FROM __all_rootservice_event_history WHERE module IN (‘major_freeze’,‘daily_merge’) ORDER BY gmt_create DESC LIMIT 100;
参考这个sql可以查询
能统计每日合并操作的磁盘量大小吗
暂时没有查询到，clog大小是实时变化的难统计 