OpenMLDB
OpenMLDB copied to clipboard
Published
20 hours ago •
4paradigm
4paradigm
Long window optimization effect for Real-time Feature processing is not obvious
Bug Description version：openmldb 0.6.1 dataset:20220814-20220821 total data：870w Real-time Feature Processing remove w10d： 9.5k qps with w10d：130 qps
CREATE TABLE deployment_test_for_error( event_id STRING, type STRING, p0 STRING, p1 STRING, p2 STRING, p3 STRING, p4 STRING, p5 STRING, p6 STRING, p7 STRING, event_occur_time TIMESTAMP, report_time TIMESTAMP, app_ver STRING, req_id STRING, device_name STRING, pro_ver STRING, INDEX(KEY=event_id, TS=event_occur_time, ttl_type=absolute, ttl=60d),INDEX(KEY=(device_name,pro_ver), TS=event_occur_time, ttl_type=absolute, ttl=60d), INDEX(KEY=(app_ver,pro_ver), TS=event_occur_time, ttl_type=absolute, ttl=60d) ) OPTIONS(partitionnum=8, replicanum=3);
DEPLOY demo_lw OPTIONS(long_windows="cat_w10d:1d,ab_w10d:1d") select count_where(device_name, pro_ver = '12.0') OVER ab_w10m AS service_click_w10m_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w30m AS service_click_w30m_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w1h AS service_click_w1h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w3h AS service_click_w3h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w7h AS service_click_w7h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w12h AS service_click_w12h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w1d AS service_click_w1d_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w10d AS service_click_w10d_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w10m AS service_subcribe_w10m_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w30m AS service_subcribe_w30m_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w1h AS service_subcribe_w1h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w3h AS service_subcribe_w3h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w7h AS service_subcribe_w7h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w12h AS service_subcribe_w12h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w1d AS service_subcribe_w1d_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w10d AS service_subcribe_w10d_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w10m AS category_click_w10m_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w30m AS category_click_w30m_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w1h AS category_click_w1h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w3h AS category_click_w3h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w7h AS category_click_w7h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w12h AS category_click_w12h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w1d AS category_click_w1d_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w10d AS category_click_w10d_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w10m AS category_subcribe_w10m_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w30m AS category_subcribe_w30m_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w1h AS category_subcribe_w1h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w3h AS category_subcribe_w3h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w7h AS category_subcribe_w7h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w12h AS category_subcribe_w12h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w1d AS category_subcribe_w1d_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w10d AS category_subcribe_w10d_cnt FROM deployment_test_for_error WINDOW ab_w10m AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10m PRECEDING AND CURRENT ROW), ab_w30m AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 30m PRECEDING AND CURRENT ROW), ab_w1h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1h PRECEDING AND CURRENT ROW), ab_w3h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 3h PRECEDING AND CURRENT ROW), ab_w7h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 7h PRECEDING AND CURRENT ROW), ab_w12h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 12h PRECEDING AND CURRENT ROW), ab_w1d AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1d PRECEDING AND CURRENT ROW), ab_w10d AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10d PRECEDING AND CURRENT ROW), cat_w10m AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10m PRECEDING AND CURRENT ROW), cat_w30m AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 30m PRECEDING AND CURRENT ROW), cat_w1h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1h PRECEDING AND CURRENT ROW), cat_w3h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 3h PRECEDING AND CURRENT ROW), cat_w7h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 7h PRECEDING AND CURRENT ROW), cat_w12h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 12h PRECEDING AND CURRENT ROW), cat_w1d AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1d PRECEDING AND CURRENT ROW), cat_w10d AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10d PRECEDING AND CURRENT ROW);
DEPLOY demo select count_where(device_name, pro_ver = '12.0') OVER ab_w10m AS service_click_w10m_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w30m AS service_click_w30m_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w1h AS service_click_w1h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w3h AS service_click_w3h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w7h AS service_click_w7h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w12h AS service_click_w12h_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w1d AS service_click_w1d_cnt, count_where(device_name, pro_ver = '12.0') OVER ab_w10d AS service_click_w10d_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w10m AS service_subcribe_w10m_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w30m AS service_subcribe_w30m_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w1h AS service_subcribe_w1h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w3h AS service_subcribe_w3h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w7h AS service_subcribe_w7h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w12h AS service_subcribe_w12h_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w1d AS service_subcribe_w1d_cnt, count_where(device_name, pro_ver = '6.1') OVER ab_w10d AS service_subcribe_w10d_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w10m AS category_click_w10m_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w30m AS category_click_w30m_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w1h AS category_click_w1h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w3h AS category_click_w3h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w7h AS category_click_w7h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w12h AS category_click_w12h_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w1d AS category_click_w1d_cnt, count_where(app_ver, pro_ver = '12.0') OVER cat_w10d AS category_click_w10d_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w10m AS category_subcribe_w10m_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w30m AS category_subcribe_w30m_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w1h AS category_subcribe_w1h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w3h AS category_subcribe_w3h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w7h AS category_subcribe_w7h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w12h AS category_subcribe_w12h_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w1d AS category_subcribe_w1d_cnt, count_where(app_ver, pro_ver = '6.1') OVER cat_w10d AS category_subcribe_w10d_cnt FROM deployment_test_for_error WINDOW ab_w10m AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10m PRECEDING AND CURRENT ROW), ab_w30m AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 30m PRECEDING AND CURRENT ROW), ab_w1h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1h PRECEDING AND CURRENT ROW), ab_w3h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 3h PRECEDING AND CURRENT ROW), ab_w7h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 7h PRECEDING AND CURRENT ROW), ab_w12h AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 12h PRECEDING AND CURRENT ROW), ab_w1d AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1d PRECEDING AND CURRENT ROW), ab_w10d AS (PARTITION BY deployment_test_for_error.device_name,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10d PRECEDING AND CURRENT ROW), cat_w10m AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10m PRECEDING AND CURRENT ROW), cat_w30m AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 30m PRECEDING AND CURRENT ROW), cat_w1h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1h PRECEDING AND CURRENT ROW), cat_w3h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 3h PRECEDING AND CURRENT ROW), cat_w7h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 7h PRECEDING AND CURRENT ROW), cat_w12h AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 12h PRECEDING AND CURRENT ROW), cat_w1d AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 1d PRECEDING AND CURRENT ROW), cat_w10d AS (PARTITION BY deployment_test_for_error.app_ver,deployment_test_for_error.pro_ver ORDER BY deployment_test_for_error.event_occur_time ROWS_RANGE BETWEEN 10d PRECEDING AND CURRENT ROW);
`10.97.152.110:6527/> select * from __INTERNAL_DB.PRE_AGG_META_INFO;
aggr_table aggr_db base_db base_table aggr_func aggr_col partition_cols order_by_col bucket_size filter_col
pre_demo_db_demo_lw_cat_w10d_count_where_app_ver_pro_ver __PRE_AGG_DB demo_db deployment_test_for_error count_where app_ver app_ver,pro_ver event_occur_time 1d pro_ver
pre_demo_db_demo_lw_cat_w10d_count_where_app_ver_pro_ver __PRE_AGG_DB demo_db deployment_test_for_error count_where app_ver app_ver,pro_ver event_occur_time 1d pro_ver
pre_demo_db_demo_lw_ab_w10d_count_where_device_name_pro_ver __PRE_AGG_DB demo_db deployment_test_for_error count_where device_name device_name,pro_ver event_occur_time 1d pro_ver
pre_demo_db_demo_lw_ab_w10d_count_where_device_name_pro_ver __PRE_AGG_DB demo_db deployment_test_for_error count_where device_name device_name,pro_ver event_occur_time 1d pro_ver `
Expected Behavior
Steps to Reproduce
版本：0.6.2 集群1060份请求样本数据压测，去除10d窗口qps 4w，带10d窗口性能降低至30qps，长窗口优化是否是处理这方面 数据内容为20220814后一周约800w条数据（数据分布整体均匀），超时时间设定为60d
版本：0.6.2 集群1060份请求样本数据压测，去除10d窗口qps 4w，带10d窗口性能降低至30qps，长窗口优化是否是处理这方面 数据内容为20220814后一周约800w条数据（数据分布整体均匀），超时时间设定为60d
@uttinie 需要几点帮忙确认的地方：
- 先执行deploy with long_windows options，再导入数据?
- 连接sql_client查看预聚合表信息
select * from __INTERNAL_DB.PRE_AGG_META_INFO; - 连接ns_client，
use __PRE_AGG_DB showtable
版本：0.6.2 集群1060份请求样本数据压测，去除10d窗口qps 4w，带10d窗口性能降低至30qps，长窗口优化是否是处理这方面 数据内容为20220814后一周约800w条数据（数据分布整体均匀），超时时间设定为60d
@uttinie 需要几点帮忙确认的地方：
- 先执行deploy with long_windows options，再导入数据?
- 连接sql_client查看预聚合表信息
select * from __INTERNAL_DB.PRE_AGG_META_INFO;- 连接ns_client，
use __PRE_AGG_DB showtable
1.先执行deploy with long_windows options，部署demo9option再导入数据 2.
--------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------
aggr_table aggr_db base_db base_table aggr_func aggr_col partition_cols order_by_col bucket_size filter_col
--------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_9 count_where app_ver app_ver,emui_ver oper_occur_time 1d emui_ver
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_9 count_where app_ver app_ver,emui_ver oper_occur_time 1d emui_ver
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_1 count_where device_name device_name,emui_ver oper_occur_time 1h emui_ver
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_1 count_where device_name device_name,emui_ver oper_occur_time 1h emui_ver
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_1 count_where device_name device_name,emui_ver oper_occur_time 1h emui_ver
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_1 count_where device_name device_name,emui_ver oper_occur_time 1h emui_ver
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_9 count_where device_name device_name,emui_ver oper_occur_time 1d emui_ver
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_9 count_where device_name device_name,emui_ver oper_occur_time 1d emui_ver
name tid pid endpoint role is_alive offset record_cnt memused diskused
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 0 10.97.152.110:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 0 10.97.152.190:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 0 10.97.152.199:9527 leader yes 0 0 0.000 5.494 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 1 10.97.152.110:9527 leader yes 0 0 0.000 5.494 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 1 10.97.152.190:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 1 10.97.152.199:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 2 10.97.152.110:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 2 10.97.152.190:9527 leader yes 0 0 0.000 5.486 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 2 10.97.152.199:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 3 10.97.152.110:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 3 10.97.152.190:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 3 10.97.152.199:9527 leader yes 0 0 0.000 5.494 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 4 10.97.152.110:9527 leader yes 0 0 0.000 5.486 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 4 10.97.152.190:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 4 10.97.152.199:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 5 10.97.152.110:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 5 10.97.152.190:9527 leader yes 0 0 0.000 5.494 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 5 10.97.152.199:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 6 10.97.152.110:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 6 10.97.152.190:9527 follower yes 0 0 0.000 3.276 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 6 10.97.152.199:9527 leader yes 0 0 0.000 5.486 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 7 10.97.152.110:9527 leader yes 0 0 0.000 5.486 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 7 10.97.152.190:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_ab_w10d_count_where_device_name_emui_ver 12 7 10.97.152.199:9527 follower yes 0 0 0.000 3.269 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 0 10.97.152.110:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 0 10.97.152.190:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 0 10.97.152.199:9527 leader yes 0 0 0.000 5.487 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 1 10.97.152.110:9527 leader yes 0 0 0.000 5.487 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 1 10.97.152.190:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 1 10.97.152.199:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 2 10.97.152.110:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 2 10.97.152.190:9527 leader yes 0 0 0.000 5.479 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 2 10.97.152.199:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 3 10.97.152.110:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 3 10.97.152.190:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 3 10.97.152.199:9527 leader yes 0 0 0.000 5.487 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 4 10.97.152.110:9527 leader yes 0 0 0.000 5.479 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 4 10.97.152.190:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 4 10.97.152.199:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 5 10.97.152.110:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 5 10.97.152.190:9527 leader yes 0 0 0.000 5.487 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 5 10.97.152.199:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 6 10.97.152.110:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 6 10.97.152.190:9527 follower yes 0 0 0.000 3.273 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 6 10.97.152.199:9527 leader yes 0 0 0.000 5.479 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 7 10.97.152.110:9527 leader yes 0 0 0.000 5.479 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 7 10.97.152.190:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w1h_cat_w10d_count_where_app_ver_emui_ver 13 7 10.97.152.199:9527 follower yes 0 0 0.000 3.266 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 0 10.97.152.110:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 0 10.97.152.190:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 0 10.97.152.199:9527 leader yes 0 0 0.000 5.492 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 1 10.97.152.110:9527 leader yes 0 0 0.000 5.492 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 1 10.97.152.190:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 1 10.97.152.199:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 2 10.97.152.110:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 2 10.97.152.190:9527 leader yes 0 0 0.000 5.484 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 2 10.97.152.199:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 3 10.97.152.110:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 3 10.97.152.190:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 3 10.97.152.199:9527 leader yes 0 0 0.000 5.492 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 4 10.97.152.110:9527 leader yes 0 0 0.000 5.484 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 4 10.97.152.190:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 4 10.97.152.199:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 5 10.97.152.110:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 5 10.97.152.190:9527 leader yes 0 0 0.000 5.492 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 5 10.97.152.199:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 6 10.97.152.110:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 6 10.97.152.190:9527 follower yes 0 0 0.000 3.274 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 6 10.97.152.199:9527 leader yes 0 0 0.000 5.484 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 7 10.97.152.110:9527 leader yes 0 0 0.000 5.484 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 7 10.97.152.190:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_ab_w10d_count_where_device_name_emui_ver 10 7 10.97.152.199:9527 follower yes 0 0 0.000 3.267 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 0 10.97.152.110:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 0 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 0 10.97.152.199:9527 leader yes 0 0 0.000 5.485 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 1 10.97.152.110:9527 leader yes 0 0 0.000 5.485 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 1 10.97.152.190:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 1 10.97.152.199:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 2 10.97.152.110:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 2 10.97.152.190:9527 leader yes 0 0 0.000 5.478 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 2 10.97.152.199:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 3 10.97.152.110:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 3 10.97.152.190:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 3 10.97.152.199:9527 leader yes 0 0 0.000 5.485 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 4 10.97.152.110:9527 leader yes 0 0 0.000 5.478 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 4 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 4 10.97.152.199:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 5 10.97.152.110:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 5 10.97.152.190:9527 leader yes 0 0 0.000 5.485 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 5 10.97.152.199:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 6 10.97.152.110:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 6 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 6 10.97.152.199:9527 leader yes 0 0 0.000 5.478 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 7 10.97.152.110:9527 leader yes 0 0 0.000 5.478 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 7 10.97.152.190:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_d1option1w_cat_w10d_count_where_app_ver_emui_ver 11 7 10.97.152.199:9527 follower yes 0 0 0.000 3.264 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 0 10.97.152.110:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 0 10.97.152.190:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 0 10.97.152.199:9527 leader yes 0 0 0.000 5.496 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 1 10.97.152.110:9527 leader yes 0 0 0.000 5.496 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 1 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 1 10.97.152.199:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 2 10.97.152.110:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 2 10.97.152.190:9527 leader yes 0 0 0.000 5.488 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 2 10.97.152.199:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 3 10.97.152.110:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 3 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 3 10.97.152.199:9527 leader yes 0 0 0.000 5.496 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 4 10.97.152.110:9527 leader yes 0 0 0.000 5.488 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 4 10.97.152.190:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 4 10.97.152.199:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 5 10.97.152.110:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 5 10.97.152.190:9527 leader yes 0 0 0.000 5.496 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 5 10.97.152.199:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 6 10.97.152.110:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 6 10.97.152.190:9527 follower yes 0 0 0.000 3.278 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 6 10.97.152.199:9527 leader yes 0 0 0.000 5.488 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 7 10.97.152.110:9527 leader yes 0 0 0.000 5.488 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 7 10.97.152.190:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_ab_w1d_count_where_device_name_emui_ver 14 7 10.97.152.199:9527 follower yes 0 0 0.000 3.271 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 0 10.97.152.110:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 0 10.97.152.190:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 0 10.97.152.199:9527 leader yes 0 0 0.000 5.489 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 1 10.97.152.110:9527 leader yes 0 0 0.000 5.489 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 1 10.97.152.190:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 1 10.97.152.199:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 2 10.97.152.110:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 2 10.97.152.190:9527 leader yes 0 0 0.000 5.481 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 2 10.97.152.199:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 3 10.97.152.110:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 3 10.97.152.190:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 3 10.97.152.199:9527 leader yes 0 0 0.000 5.489 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 4 10.97.152.110:9527 leader yes 0 0 0.000 5.481 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 4 10.97.152.190:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 4 10.97.152.199:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 5 10.97.152.110:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 5 10.97.152.190:9527 leader yes 0 0 0.000 5.489 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 5 10.97.152.199:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 6 10.97.152.110:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 6 10.97.152.190:9527 follower yes 0 0 0.000 3.275 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 6 10.97.152.199:9527 leader yes 0 0 0.000 5.481 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 7 10.97.152.110:9527 leader yes 0 0 0.000 5.481 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 7 10.97.152.190:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo1optionw1h1_cat_w1d_count_where_app_ver_emui_ver 15 7 10.97.152.199:9527 follower yes 0 0 0.000 3.268 K
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.110:9527 leader yes 2015222 2015222 233.535 M 457.029 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.190:9527 follower yes 2015222 2015222 233.535 M 457.027 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.199:9527 follower yes 2015222 2015222 233.535 M 457.027 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.110:9527 follower yes 2144844 2144844 248.256 M 485.415 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.190:9527 leader yes 2144844 2144844 248.256 M 485.417 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.199:9527 follower yes 2144844 2144844 248.256 M 485.415 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.110:9527 follower yes 1129660 1129660 130.787 M 256.003 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.190:9527 follower yes 1129660 1129660 130.787 M 256.003 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.199:9527 leader yes 1129660 1129660 130.787 M 256.005 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.110:9527 leader yes 2353668 2353668 272.239 M 532.379 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.190:9527 follower yes 2353668 2353668 272.239 M 532.377 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.199:9527 follower yes 2353668 2353668 272.239 M 532.377 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.110:9527 follower yes 2021362 2021362 234.030 M 457.730 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.190:9527 leader yes 2021362 2021362 234.030 M 457.732 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.199:9527 follower yes 2021362 2021362 234.030 M 457.730 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.110:9527 follower yes 1641548 1641548 189.189 M 367.825 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.190:9527 follower yes 1641548 1641548 189.189 M 367.825 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.199:9527 leader yes 1641548 1641548 189.189 M 367.827 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.110:9527 leader yes 2718716 2718716 313.717 M 612.919 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.190:9527 follower yes 2718716 2718716 313.717 M 612.917 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.199:9527 follower yes 2718716 2718716 313.717 M 612.917 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.110:9527 follower yes 2706864 2706864 311.869 M 608.200 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.190:9527 leader yes 2706864 2706864 311.869 M 608.203 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.199:9527 follower yes 2706864 2706864 311.869 M 608.200 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.110:9527 leader yes 2360142 2360142 275.700 M 553.843 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.190:9527 follower yes 2360142 2360142 275.700 M 553.841 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.199:9527 follower yes 2360142 2360142 275.700 M 553.841 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.110:9527 follower yes 5724616 5724616 674.867 M 1.342 G
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.190:9527 leader yes 5724616 5724616 674.867 M 1.342 G
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.199:9527 follower yes 5724616 5724616 674.867 M 1.342 G
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.110:9527 follower yes 104630 104630 12.336 M 24.953 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.190:9527 follower yes 104630 104630 12.336 M 24.953 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.199:9527 leader yes 104630 104630 12.336 M 24.955 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.110:9527 leader yes 4104528 4104528 483.740 M 983.350 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.190:9527 follower yes 4104528 4104528 483.740 M 983.348 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.199:9527 follower yes 4104528 4104528 483.740 M 983.348 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.110:9527 follower yes 2815770 2815770 329.286 M 663.114 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.190:9527 leader yes 2815770 2815770 329.286 M 663.116 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.199:9527 follower yes 2815770 2815770 329.286 M 663.114 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.110:9527 follower yes 1716784 1716784 200.419 M 401.944 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.190:9527 follower yes 1716784 1716784 200.419 M 401.944 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.199:9527 leader yes 1716784 1716784 200.419 M 401.947 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.110:9527 leader yes 116958 116958 13.671 M 27.424 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.190:9527 follower yes 116958 116958 13.671 M 27.422 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.199:9527 follower yes 116958 116958 13.671 M 27.422 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.110:9527 follower yes 67906 67906 7.896 M 7.873 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.190:9527 leader yes 67906 67906 7.896 M 7.875 M
pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.199:9527 follower yes 67906 67906 7.896 M 7.873 M
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver
@uttinie
- 导入数据是否按照时间顺序，由小到大导入的？
-
pro_ver的取值有多少？只有12.0和6.1两个取值么？ - 可以在ns client上，执行
use demo_db
showtable
- 在sql client上执行
select * from __PRE_AGG_DB.pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver limit 100;
select * from __PRE_AGG_DB.pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver limit 100;
- 在logs/tablet.INFO里查看，是否有
aggregator failed或者table is not exist的相关错误日志
观察到预聚合表的数据量过大，每张表的数据量在1600w，比原始数据量还要大。
pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver
@uttinie
- 导入数据是否按照时间顺序，由小到大导入的？
pro_ver的取值有多少？只有12.0和6.1两个取值么？- 可以在ns client上，执行
use demo_db showtable
- 在sql client上执行
select * from __PRE_AGG_DB.pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver limit 100; select * from __PRE_AGG_DB.pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver limit 100;
- 在logs/tablet.INFO里查看，是否有
aggregator failed或者table is not exist的相关错误日志观察到预聚合表的数据量过大，每张表的数据量在1600w，比原始数据量还要大。
- 导入数据是否按照时间顺序，由小到大导入的？文件夹100个文件不确认导入逻辑，无法控制
- pro_ver的取值有15种
- showtable
shopping_log_info_table_9 6 0 10.97.152.110:9527 leader yes 3049084 1103219 1.652 G 3.152 G
shopping_log_info_table_9 6 0 10.97.152.190:9527 follower yes 3049084 1103219 1.652 G 3.152 G
shopping_log_info_table_9 6 0 10.97.152.199:9527 follower yes 3049084 1103219 1.652 G 3.152 G
shopping_log_info_table_9 6 1 10.97.152.110:9527 follower yes 4302781 1095515 2.406 G 2.617 G
shopping_log_info_table_9 6 1 10.97.152.190:9527 leader yes 4302781 1095515 2.406 G 2.617 G
shopping_log_info_table_9 6 1 10.97.152.199:9527 follower yes 4302781 1095515 2.406 G 2.617 G
shopping_log_info_table_9 6 2 10.97.152.110:9527 follower yes 1656957 1087918 962.466 M 1.769 G
shopping_log_info_table_9 6 2 10.97.152.190:9527 follower yes 1656957 1087918 962.466 M 1.769 G
shopping_log_info_table_9 6 2 10.97.152.199:9527 leader yes 1656957 1087918 962.466 M 1.769 G
shopping_log_info_table_9 6 3 10.97.152.110:9527 leader yes 3714069 1094146 2.085 G 3.986 G
shopping_log_info_table_9 6 3 10.97.152.190:9527 follower yes 3714069 1094146 2.085 G 3.986 G
shopping_log_info_table_9 6 3 10.97.152.199:9527 follower yes 3714069 1094146 2.085 G 3.986 G
shopping_log_info_table_9 6 4 10.97.152.110:9527 follower yes 3320962 1168166 1.784 G 3.405 G
shopping_log_info_table_9 6 4 10.97.152.190:9527 leader yes 3320962 1168166 1.784 G 3.405 G
shopping_log_info_table_9 6 4 10.97.152.199:9527 follower yes 3320962 1168166 1.784 G 3.405 G
shopping_log_info_table_9 6 5 10.97.152.110:9527 follower yes 2568285 1092554 1.434 G 2.729 G
shopping_log_info_table_9 6 5 10.97.152.190:9527 follower yes 2568285 1092554 1.434 G 2.729 G
shopping_log_info_table_9 6 5 10.97.152.199:9527 leader yes 2568285 1092554 1.434 G 2.729 G
shopping_log_info_table_9 6 6 10.97.152.110:9527 leader yes 2387630 1092297 1.334 G 2.533 G
shopping_log_info_table_9 6 6 10.97.152.190:9527 follower yes 2387630 1092297 1.334 G 2.533 G
shopping_log_info_table_9 6 6 10.97.152.199:9527 follower yes 2387630 1092297 1.334 G 2.533 G
shopping_log_info_table_9 6 7 10.97.152.110:9527 follower yes 2368115 1084837 1.303 G 2.473 G
shopping_log_info_table_9 6 7 10.97.152.190:9527 leader yes 2368115 1084837 1.303 G 2.473 G
shopping_log_info_table_9 6 7 10.97.152.199:9527 follower yes 2368115 1084837 1.303 G 2.473 G
- sql client执行
select * from __PRE_AGG_DB.pre_demo_db_demo9option_ab_w10d_count_where_device_name_emui_ver limit 100;
-------------- --------------- --------------- ---------- ---------- --------------- ------------
key ts_start ts_end num_rows agg_val binlog_offset filter_key
-------------- --------------- --------------- ---------- ---------- --------------- ------------
ARS-TL00|9.1 1661040000000 1661126399999 30 2415809 9.1
ARS-TL00|9.1 1661040000000 1661126399999 29 2415809 9.1
ARS-TL00|9.1 1661040000000 1661126399999 28 2415808 9.1
ARS-TL00|9.1 1661040000000 1661126399999 27 415808 9.1
ARS-TL00|9.1 1661040000000 1661126399999 26 2415807 9.1
ARS-TL00|9.1 1661040000000 1661126399999 25 2415807 9.1
ARS-TL00|9.1 1661040000000 1661126399999 24 2197227 9.1
ARS-TL00|9.1 1661040000000 1661126399999 24 2197227 9.1
ARS-TL00|9.1 1660953600000 1661039999999 50 2 2732157 9.1
ARS-TL00|9.1 1660953600000 1661039999999 49 1 2732157 9.1
ARS-TL00|9.1 1660953600000 1661039999999 48 0 2732156 9.1
ARS-TL00|9.1 1660953600000 1661039999999 47 / 2732156 9.1
ARS-TL00|9.1 1660953600000 1661039999999 46 . 2732155 9.1
ARS-TL00|9.1 1660953600000 1661039999999 45 - 2732155 9.1
ARS-TL00|9.1 1660953600000 1661039999999 44 , 2645967 9.1
ARS-TL00|9.1 1660953600000 1661039999999 43 + 2645967 9.1
ARS-TL00|9.1 1660953600000 1661039999999 42 * 2645966 9.1
ARS-TL00|9.1 1660953600000 1661039999999 41 ) 2645966 9.1
ARS-TL00|9.1 1660953600000 1661039999999 40 ( 2645965 9.1
ARS-TL00|9.1 1660953600000 1661039999999 39 ' 2645965 9.1
ARS-TL00|9.1 1660953600000 1661039999999 38 & 2645964 9.1
ARS-TL00|9.1 1660953600000 1661039999999 37 % 2645964 9.1
ARS-TL00|9.1 1660953600000 1661039999999 36 $ 2645963 9.1
ARS-TL00|9.1 1660953600000 1661039999999 35 # 2645963 9.1
ARS-TL00|9.1 1660953600000 1661039999999 34 " 2645962 9.1
ARS-TL00|9.1 1660953600000 1661039999999 33 ! 2645962 9.1
ARS-TL00|9.1 1660953600000 1661039999999 32 2361525 9.1
ARS-TL00|9.1 1660953600000 1661039999999 31 2361525 9.1
ARS-TL00|9.1 1660953600000 1661039999999 30 2361524 9.1
ARS-TL00|9.1 1660953600000 1661039999999 29 2361524 9.1
ARS-TL00|9.1 1660953600000 1661039999999 28 2361523 9.1
ARS-TL00|9.1 1660953600000 1661039999999 27 361523 9.1
ARS-TL00|9.1 1660953600000 1661039999999 26 1438563 9.1
ARS-TL00|9.1 1660953600000 1661039999999 25 1438563 9.1
ARS-TL00|9.1 1660953600000 1661039999999 24 1035643 9.1
ARS-TL00|9.1 1660953600000 1661039999999 23 1035643 9.1
ARS-TL00|9.1 1660953600000 1661039999999 22 777291 9.1
ARS-TL00|9.1 1660953600000 1661039999999 21 777291 9.1
ARS-TL00|9.1 1660953600000 1661039999999 20 777290 9.1
ARS-TL00|9.1 1660953600000 1661039999999 19 777290 9.1
ARS-TL00|9.1 1660953600000 1661039999999 18 777281 9.1
ARS-TL00|9.1 1660953600000 1661039999999 17 777281 9.1
ARS-TL00|9.1 1660953600000 1661039999999 16 777269 9.1
ARS-TL00|9.1 1660953600000 1661039999999 15 777269 9.1
ARS-TL00|9.1 1660953600000 1661039999999 14 777251 9.1
777251 9.1 1661039999999 13
ARS-TL00|9.1 1660953600000 1661039999999 12
549803 9.1
ARS-TL00|9.1 1660953600000 1661039999999 11
549803 9.1
ARS-TL00|9.1 1660953600000 1661039999999 10
549800 9.1
ARS-TL00|9.1 1660953600000 1661039999999 9 549800 9.1
ARS-TL00|9.1 1660953600000 1661039999999 8 549799 9.1
ARS-TL00|9.1 1660953600000 1661039999999 7 549799 9.1
ARS-TL00|9.1 1660953600000 1661039999999 6 549795 9.1
ARS-TL00|9.1 1660953600000 1661039999999 5 549795 9.1
ARS-TL00|9.1 1660953600000 1661039999999 4 549790 9.1
ARS-TL00|9.1 1660953600000 1661039999999 3 549790 9.1
ARS-TL00|9.1 1660953600000 1661039999999 2 549788 9.1
ARS-TL00|9.1 1660953600000 1661039999999 1 549788 9.1
ARS-TL00|9.1 1660867200000 1660953599999 67 C 2827604 9.1
ARS-TL00|9.1 1660867200000 1660953599999 66 B 2827604 9.1
ARS-TL00|9.1 1660867200000 1660953599999 65 A 2827603 9.1
ARS-TL00|9.1 1660867200000 1660953599999 64 @ 2827603 9.1
ARS-TL00|9.1 1660867200000 1660953599999 63 ? 2827602 9.1
ARS-TL00|9.1 1660867200000 1660953599999 62 > 2827602 9.1
ARS-TL00|9.1 1660867200000 1660953599999 61 = 2039876 9.1
ARS-TL00|9.1 1660867200000 1660953599999 60 < 2039876 9.1
ARS-TL00|9.1 1660867200000 1660953599999 59 ; 2039866 9.1
ARS-TL00|9.1 1660867200000 1660953599999 58 : 2039866 9.1
ARS-TL00|9.1 1660867200000 1660953599999 57 9 2039851 9.1
ARS-TL00|9.1 1660867200000 1660953599999 56 8 2039851 9.1
ARS-TL00|9.1 1660867200000 1660953599999 55 7 2039823 9.1
ARS-TL00|9.1 1660867200000 1660953599999 54 6 2039823 9.1
ARS-TL00|9.1 1660867200000 1660953599999 53 5 2039814 9.1
ARS-TL00|9.1 1660867200000 1660953599999 52 4 2039814 9.1
ARS-TL00|9.1 1660867200000 1660953599999 51 3 2039809 9.1
ARS-TL00|9.1 1660867200000 1660953599999 50 2 2039809 9.1
ARS-TL00|9.1 1660867200000 1660953599999 49 1 2039794 9.1
ARS-TL00|9.1 1660867200000 1660953599999 48 0 2039794 9.1
ARS-TL00|9.1 1660867200000 1660953599999 47 / 1710070 9.1
ARS-TL00|9.1 1660867200000 1660953599999 46 . 1710070 9.1
ARS-TL00|9.1 1660867200000 1660953599999 45 - 1710049 9.1
ARS-TL00|9.1 1660867200000 1660953599999 44 , 1710049 9.1
ARS-TL00|9.1 1660867200000 1660953599999 43 + 1710035 9.1
ARS-TL00|9.1 1660867200000 1660953599999 42 * 1710035 9.1
ARS-TL00|9.1 1660867200000 1660953599999 41 ) 1402358 9.1
ARS-TL00|9.1 1660867200000 1660953599999 40 ( 1402358 9.1
ARS-TL00|9.1 1660867200000 1660953599999 39 ' 1402350 9.1
ARS-TL00|9.1 1660867200000 1660953599999 38 & 1402350 9.1
ARS-TL00|9.1 1660867200000 1660953599999 37 % 1402347 9.1
ARS-TL00|9.1 1660867200000 1660953599999 36 $ 1402347 9.1
ARS-TL00|9.1 1660867200000 1660953599999 35 # 843594 9.1
ARS-TL00|9.1 1660867200000 1660953599999 34 " 843594 9.1
ARS-TL00|9.1 1660867200000 1660953599999 33 ! 843587 9.1
ARS-TL00|9.1 1660867200000 1660953599999 32 843587 9.1
ARS-TL00|9.1 1660867200000 1660953599999 31 843582 9.1
ARS-TL00|9.1 1660867200000 1660953599999 30 843582 9.1
ARS-TL00|9.1 1660867200000 1660953599999 29 639335 9.1
ARS-TL00|9.1 1660867200000 1660953599999 28 639335 9.1
ARS-TL00|9.1 1660867200000 1660953599999 27 39334 9.1
ARS-TL00|9.1 1660867200000 1660953599999 26 639334 9.1
-------------- --------------- --------------- ---------- ---------- --------------- ------------
select * from __PRE_AGG_DB.pre_demo_db_demo9option_cat_w10d_count_where_app_ver_emui_ver limit 100;
----------------- --------------- --------------- ---------- ---------- --------------- ------------
key ts_start ts_end num_rows agg_val binlog_offset filter_key
----------------- --------------- --------------- ---------- ---------- --------------- ------------
12.0.5.300|13.0 1661040000000 1661126399999 44 , 1232150 13.0
12.0.5.300|13.0 1661040000000 1661126399999 43 + 1232150 13.0
12.0.5.300|13.0 1661040000000 1661126399999 42 * 1232149 13.0
12.0.5.300|13.0 1661040000000 1661126399999 41 ) 1232149 13.0
12.0.5.300|13.0 1661040000000 1661126399999 40 ( 1232148 13.0
12.0.5.300|13.0 1661040000000 1661126399999 39 ' 1232148 13.0
12.0.5.300|13.0 1661040000000 1661126399999 38 & 1087864 13.0
12.0.5.300|13.0 1661040000000 1661126399999 37 % 1087864 13.0
12.0.5.300|13.0 1661040000000 1661126399999 36 $ 1087863 13.0
12.0.5.300|13.0 1661040000000 1661126399999 35 # 1087863 13.0
12.0.5.300|13.0 1661040000000 1661126399999 34 " 1087862 13.0
12.0.5.300|13.0 1661040000000 1661126399999 33 ! 1087862 13.0
12.0.5.300|13.0 1661040000000 1661126399999 32 940367 13.0
12.0.5.300|13.0 1661040000000 1661126399999 31 940367 13.0
12.0.5.300|13.0 1661040000000 1661126399999 30 940364 13.0
12.0.5.300|13.0 1661040000000 1661126399999 29 940364 13.0
12.0.5.300|13.0 1661040000000 1661126399999 28 940363 13.0
12.0.5.300|13.0 1661040000000 1661126399999 27 40363 13.0
12.0.5.300|13.0 1661040000000 1661126399999 26 645146 13.0
12.0.5.300|13.0 1661040000000 1661126399999 25 645146 13.0
12.0.5.300|13.0 1661040000000 1661126399999 24 645144 13.0
12.0.5.300|13.0 1661040000000 1661126399999 23 645144 13.0
12.0.5.300|13.0 1661040000000 1661126399999 22 645143 13.0
12.0.5.300|13.0 1661040000000 1661126399999 21 645143 13.0
12.0.5.300|13.0 1661040000000 1661126399999 20 602144 13.0
12.0.5.300|13.0 1661040000000 1661126399999 19 602144 13.0
12.0.5.300|13.0 1661040000000 1661126399999 18 602136 13.0
12.0.5.300|13.0 1661040000000 1661126399999 17 602136 13.0
12.0.5.300|13.0 1661040000000 1661126399999 16 602133 13.0
12.0.5.300|13.0 1661040000000 1661126399999 15 602133 13.0
12.0.5.300|13.0 1661040000000 1661126399999 14 582047 13.0
582047 13.0 00 1661126399999 13
12.0.5.300|13.0 1661040000000 1661126399999 12
582045 13.0
12.0.5.300|13.0 1661040000000 1661126399999 11
582045 13.0
12.0.5.300|13.0 1661040000000 1661126399999 10
575327 13.0
12.0.5.300|13.0 1661040000000 1661126399999 9 575327 13.0
12.0.5.300|13.0 1661040000000 1661126399999 8 575326 13.0
12.0.5.300|13.0 1661040000000 1661126399999 7 575326 13.0
12.0.5.300|13.0 1661040000000 1661126399999 6 426534 13.0
12.0.5.300|13.0 1661040000000 1661126399999 6 426534 13.0
12.0.5.300|13.0 1660953600000 1661039999999 23 1330398 13.0
12.0.5.300|13.0 1660953600000 1661039999999 22 1330398 13.0
12.0.5.300|13.0 1660953600000 1661039999999 21 1330397 13.0
12.0.5.300|13.0 1660953600000 1661039999999 20 1330397 13.0
12.0.5.300|13.0 1660953600000 1661039999999 19 1098705 13.0
12.0.5.300|13.0 1660953600000 1661039999999 18 1098705 13.0
12.0.5.300|13.0 1660953600000 1661039999999 17 1098704 13.0
12.0.5.300|13.0 1660953600000 1661039999999 16 1098704 13.0
12.0.5.300|13.0 1660953600000 1661039999999 15 1098703 13.0
12.0.5.300|13.0 1660953600000 1661039999999 14 1098703 13.0
1067008 13.0 00 1661039999999 13
12.0.5.300|13.0 1660953600000 1661039999999 12
1067008 13.0
12.0.5.300|13.0 1660953600000 1661039999999 11
571739 13.0
12.0.5.300|13.0 1660953600000 1661039999999 10
571739 13.0
12.0.5.300|13.0 1660953600000 1661039999999 9 539175 13.0
12.0.5.300|13.0 1660953600000 1661039999999 8 539175 13.0
12.0.5.300|13.0 1660953600000 1661039999999 7 539173 13.0
12.0.5.300|13.0 1660953600000 1661039999999 6 539173 13.0
12.0.5.300|13.0 1660953600000 1661039999999 5 388453 13.0
12.0.5.300|13.0 1660953600000 1661039999999 4 388453 13.0
12.0.5.300|13.0 1660953600000 1661039999999 3 1337 13.0
12.0.5.300|13.0 1660953600000 1661039999999 3 1337 13.0
12.0.5.300|13.0 1660867200000 1660953599999 72 H 1560550 13.0
12.0.5.300|13.0 1660867200000 1660953599999 71 G 1560550 13.0
12.0.5.300|13.0 1660867200000 1660953599999 70 F 1560549 13.0
12.0.5.300|13.0 1660867200000 1660953599999 69 E 1560549 13.0
12.0.5.300|13.0 1660867200000 1660953599999 68 D 1443092 13.0
12.0.5.300|13.0 1660867200000 1660953599999 67 C 1443092 13.0
12.0.5.300|13.0 1660867200000 1660953599999 66 B 1443091 13.0
12.0.5.300|13.0 1660867200000 1660953599999 65 A 1443091 13.0
12.0.5.300|13.0 1660867200000 1660953599999 64 @ 1443090 13.0
12.0.5.300|13.0 1660867200000 1660953599999 63 ? 1443090 13.0
12.0.5.300|13.0 1660867200000 1660953599999 62 > 1422415 13.0
12.0.5.300|13.0 1660867200000 1660953599999 61 = 1422415 13.0
12.0.5.300|13.0 1660867200000 1660953599999 60 < 1422414 13.0
12.0.5.300|13.0 1660867200000 1660953599999 59 ; 1422414 13.0
12.0.5.300|13.0 1660867200000 1660953599999 58 : 1417158 13.0
12.0.5.300|13.0 1660867200000 1660953599999 57 9 1417158 13.0
12.0.5.300|13.0 1660867200000 1660953599999 56 8 1261083 13.0
12.0.5.300|13.0 1660867200000 1660953599999 55 7 1261083 13.0
12.0.5.300|13.0 1660867200000 1660953599999 54 6 1261082 13.0
12.0.5.300|13.0 1660867200000 1660953599999 53 5 1261082 13.0
12.0.5.300|13.0 1660867200000 1660953599999 52 4 1261081 13.0
12.0.5.300|13.0 1660867200000 1660953599999 51 3 1261081 13.0
12.0.5.300|13.0 1660867200000 1660953599999 50 2 964996 13.0
12.0.5.300|13.0 1660867200000 1660953599999 49 1 964996 13.0
12.0.5.300|13.0 1660867200000 1660953599999 48 0 964993 13.0
12.0.5.300|13.0 1660867200000 1660953599999 47 / 964993 13.0
12.0.5.300|13.0 1660867200000 1660953599999 46 . 942901 13.0
12.0.5.300|13.0 1660867200000 1660953599999 45 - 942901 13.0
12.0.5.300|13.0 1660867200000 1660953599999 44 , 942898 13.0
12.0.5.300|13.0 1660867200000 1660953599999 43 + 942898 13.0
12.0.5.300|13.0 1660867200000 1660953599999 42 * 832364 13.0
12.0.5.300|13.0 1660867200000 1660953599999 41 ) 832364 13.0
12.0.5.300|13.0 1660867200000 1660953599999 40 ( 832363 13.0
12.0.5.300|13.0 1660867200000 1660953599999 39 ' 832363 13.0
12.0.5.300|13.0 1660867200000 1660953599999 38 & 832362 13.0
12.0.5.300|13.0 1660867200000 1660953599999 37 % 832362 13.0
12.0.5.300|13.0 1660867200000 1660953599999 36 $ 815966 13.0
12.0.5.300|13.0 1660867200000 1660953599999 35 # 815966 13.0
----------------- --------------- --------------- ---------- ---------- --------------- ------------
- 在logs/tablet.INFO里查看，是否有aggregator failed或者table is not exist的相关错误日志 无
10.97.152.110:6527/demo_db> select * from __INTERNAL_DB.PRE_AGG_META_INFO;
-------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------
aggr_table aggr_db base_db base_table aggr_func aggr_col partition_cols order_by_col bucket_size filter_col
-------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_8 count_where device_name device_name,emui_ver oper_occur_time 1h emui_ver
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver __PRE_AGG_DB demo_db shopping_log_info_table_8 count_where app_ver app_ver,emui_ver oper_occur_time 1h emui_ver
-------------------------------------------------------------------- -------------- --------- --------------------------- ------------- ------------- ---------------------- ----------------- ------------- ------------
10.97.152.110:6527 demo_db> showtable
name tid pid endpoint role is_alive offset record_cnt memused diskused
--------------------------------------------------------------------------------------------------------------------------
shopping_log_info_table_8 6 0 10.97.152.110:9527 leader yes 3049084 1103219 1.652 G 1.576 G
shopping_log_info_table_8 6 0 10.97.152.190:9527 follower yes 3049084 1103219 1.652 G 1.576 G
shopping_log_info_table_8 6 0 10.97.152.199:9527 follower yes 3049084 1103219 1.652 G 1.576 G
shopping_log_info_table_8 6 1 10.97.152.110:9527 follower yes 4302781 1095515 2.406 G 2.309 G
shopping_log_info_table_8 6 1 10.97.152.190:9527 leader yes 4302781 1095515 2.406 G 2.309 G
shopping_log_info_table_8 6 1 10.97.152.199:9527 follower yes 4302781 1095515 2.406 G 2.309 G
shopping_log_info_table_8 6 2 10.97.152.110:9527 follower yes 1656957 1087918 962.466 M 905.859 M
shopping_log_info_table_8 6 2 10.97.152.190:9527 follower yes 1656957 1087918 962.466 M 905.859 M
shopping_log_info_table_8 6 2 10.97.152.199:9527 leader yes 1656957 1087918 962.466 M 905.859 M
shopping_log_info_table_8 6 3 10.97.152.110:9527 leader yes 3714069 1094146 2.085 G 1.993 G
shopping_log_info_table_8 6 3 10.97.152.190:9527 follower yes 3714069 1094146 2.085 G 1.993 G
shopping_log_info_table_8 6 3 10.97.152.199:9527 follower yes 3714069 1094146 2.085 G 1.993 G
shopping_log_info_table_8 6 4 10.97.152.110:9527 follower yes 3320962 1168166 1.784 G 1.702 G
shopping_log_info_table_8 6 4 10.97.152.190:9527 leader yes 3320962 1168166 1.784 G 1.702 G
shopping_log_info_table_8 6 4 10.97.152.199:9527 follower yes 3320962 1168166 1.784 G 1.702 G
shopping_log_info_table_8 6 5 10.97.152.110:9527 follower yes 2568285 1092554 1.434 G 1.364 G
shopping_log_info_table_8 6 5 10.97.152.190:9527 follower yes 2568285 1092554 1.434 G 1.364 G
shopping_log_info_table_8 6 5 10.97.152.199:9527 leader yes 2568285 1092554 1.434 G 1.364 G
shopping_log_info_table_8 6 6 10.97.152.110:9527 leader yes 2387630 1092297 1.334 G 1.266 G
shopping_log_info_table_8 6 6 10.97.152.190:9527 follower yes 2387630 1092297 1.334 G 1.266 G
shopping_log_info_table_8 6 6 10.97.152.199:9527 follower yes 2387630 1092297 1.334 G 1.266 G
shopping_log_info_table_8 6 7 10.97.152.110:9527 follower yes 2368115 1084837 1.303 G 1.236 G
shopping_log_info_table_8 6 7 10.97.152.190:9527 leader yes 2368115 1084837 1.303 G 1.236 G
shopping_log_info_table_8 6 7 10.97.152.199:9527 follower yes 2368115 1084837 1.303 G 1.236 G
10.97.152.110:6527/demo_db> select * from __PRE_AGG_DB.pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver limit 100;
-------------- --------------- --------------- ---------- ---------- --------------- ------------
key ts_start ts_end num_rows agg_val binlog_offset filter_key
-------------- --------------- --------------- ---------- ---------- --------------- ------------
AGS2-W09|9.1 1661137200000 1661140799999 43 + 1636067 9.1
AGS2-W09|9.1 1661137200000 1661140799999 42 * 1636066 9.1
AGS2-W09|9.1 1661137200000 1661140799999 41 ) 1636065 9.1
AGS2-W09|9.1 1661137200000 1661140799999 40 ( 1239135 9.1
AGS2-W09|9.1 1661133600000 1661137199999 3 1577549 9.1
AGS2-W09|9.1 1661133600000 1661137199999 2 1577548 9.1
AGS2-W09|9.1 1661133600000 1661137199999 1 1577547 9.1
AGS2-W09|9.1 1661130000000 1661133599999 12
1448441 9.1
AGS2-W09|9.1 1661130000000 1661133599999 11
1448440 9.1
AGS2-W09|9.1 1661130000000 1661133599999 10
1448439 9.1
AGS2-W09|9.1 1661130000000 1661133599999 9 1447454 9.1
AGS2-W09|9.1 1661130000000 1661133599999 8 1447453 9.1
AGS2-W09|9.1 1661130000000 1661133599999 7 1447451 9.1
AGS2-W09|9.1 1661130000000 1661133599999 6 1443780 9.1
AGS2-W09|9.1 1661130000000 1661133599999 5 1443777 9.1
AGS2-W09|9.1 1661130000000 1661133599999 4 1443768 9.1
AGS2-W09|9.1 1661130000000 1661133599999 3 1432634 9.1
AGS2-W09|9.1 1661130000000 1661133599999 2 1432633 9.1
AGS2-W09|9.1 1661130000000 1661133599999 1 1432631 9.1
AGS2-W09|9.1 1661119200000 1661122799999 6 1067795 9.1
AGS2-W09|9.1 1661094000000 1661097599999 6 1495228 9.1
AGS2-W09|9.1 1661094000000 1661097599999 5 1495227 9.1
AGS2-W09|9.1 1661094000000 1661097599999 4 1495225 9.1
AGS2-W09|9.1 1661094000000 1661097599999 3 1434204 9.1
AGS2-W09|9.1 1661094000000 1661097599999 2 1434203 9.1
AGS2-W09|9.1 1661094000000 1661097599999 1 1434202 9.1
AGS2-W09|9.1 1661090400000 1661093999999 3 1233298 9.1
AGS2-W09|9.1 1661090400000 1661093999999 2 1233296 9.1
AGS2-W09|9.1 1661090400000 1661093999999 1 1233295 9.1
AGS2-W09|9.1 1661083200000 1661086799999 2 817012 9.1
AGS2-W09|9.1 1661079600000 1661083199999 5 499837 9.1
AGS2-W09|9.1 1661076000000 1661079599999 8 342400 9.1
AGS2-W09|9.1 1661072400000 1661075999999 4 982547 9.1
AGS2-W09|9.1 1661072400000 1661075999999 3 982546 9.1
AGS2-W09|9.1 1661072400000 1661075999999 2 982545 9.1
AGS2-W09|9.1 1661072400000 1661075999999 1 982392 9.1
AGS2-W09|9.1 1661068800000 1661072399999 18 818446 9.1
AGS2-W09|9.1 1661068800000 1661072399999 17 818445 9.1
AGS2-W09|9.1 1661068800000 1661072399999 16 818444 9.1
AGS2-W09|9.1 1661068800000 1661072399999 15 812417 9.1
AGS2-W09|9.1 1661068800000 1661072399999 14 812321 9.1
812254 9.1 1661072399999 13
AGS2-W09|9.1 1661068800000 1661072399999 12
810931 9.1
AGS2-W09|9.1 1661068800000 1661072399999 11
810928 9.1
AGS2-W09|9.1 1661068800000 1661072399999 10
809564 9.1
AGS2-W09|9.1 1661068800000 1661072399999 9 742565 9.1
AGS2-W09|9.1 1661068800000 1661072399999 8 742563 9.1
AGS2-W09|9.1 1661068800000 1661072399999 7 742560 9.1
AGS2-W09|9.1 1661068800000 1661072399999 6 639771 9.1
AGS2-W09|9.1 1661068800000 1661072399999 5 639770 9.1
AGS2-W09|9.1 1661068800000 1661072399999 4 639769 9.1
AGS2-W09|9.1 1661068800000 1661072399999 3 639699 9.1
AGS2-W09|9.1 1661068800000 1661072399999 2 639538 9.1
AGS2-W09|9.1 1661068800000 1661072399999 1 639505 9.1
AGS2-W09|9.1 1661065200000 1661068799999 6 488488 9.1
AGS2-W09|9.1 1661065200000 1661068799999 5 488476 9.1
AGS2-W09|9.1 1661065200000 1661068799999 4 488466 9.1
AGS2-W09|9.1 1661065200000 1661068799999 3 422213 9.1
AGS2-W09|9.1 1661065200000 1661068799999 2 422193 9.1
AGS2-W09|9.1 1661065200000 1661068799999 1 422181 9.1
AGS2-W09|9.1 1661061600000 1661065199999 22 231186 9.1
AGS2-W09|9.1 1661061600000 1661065199999 21 231182 9.1
AGS2-W09|9.1 1661061600000 1661065199999 20 231181 9.1
AGS2-W09|9.1 1661061600000 1661065199999 19 230382 9.1
AGS2-W09|9.1 1661061600000 1661065199999 18 230375 9.1
AGS2-W09|9.1 1661061600000 1661065199999 17 230373 9.1
AGS2-W09|9.1 1661061600000 1661065199999 16 226396 9.1
AGS2-W09|9.1 1661061600000 1661065199999 15 226393 9.1
AGS2-W09|9.1 1661061600000 1661065199999 14 226392 9.1
218199 9.1 1661065199999 13
AGS2-W09|9.1 1661061600000 1661065199999 12
218196 9.1
AGS2-W09|9.1 1661061600000 1661065199999 11
218195 9.1
AGS2-W09|9.1 1661061600000 1661065199999 10
214285 9.1
AGS2-W09|9.1 1661061600000 1661065199999 9 214282 9.1
AGS2-W09|9.1 1661061600000 1661065199999 8 214280 9.1
AGS2-W09|9.1 1661061600000 1661065199999 7 214220 9.1
AGS2-W09|9.1 1661061600000 1661065199999 6 213854 9.1
AGS2-W09|9.1 1661061600000 1661065199999 5 213851 9.1
AGS2-W09|9.1 1661061600000 1661065199999 4 213848 9.1
AGS2-W09|9.1 1661061600000 1661065199999 3 191684 9.1
AGS2-W09|9.1 1661061600000 1661065199999 2 191683 9.1
AGS2-W09|9.1 1661061600000 1661065199999 1 191680 9.1
AGS2-W09|9.1 1661054400000 1661057999999 12
641862 9.1
AGS2-W09|9.1 1661054400000 1661057999999 11
641860 9.1
AGS2-W09|9.1 1661054400000 1661057999999 10
641856 9.1
AGS2-W09|9.1 1661054400000 1661057999999 9 640883 9.1
AGS2-W09|9.1 1661054400000 1661057999999 8 640882 9.1
AGS2-W09|9.1 1661054400000 1661057999999 7 640881 9.1
AGS2-W09|9.1 1661054400000 1661057999999 6 493488 9.1
AGS2-W09|9.1 1661054400000 1661057999999 5 493468 9.1
AGS2-W09|9.1 1661054400000 1661057999999 4 493450 9.1
AGS2-W09|9.1 1661054400000 1661057999999 3 492790 9.1
AGS2-W09|9.1 1661054400000 1661057999999 2 492789 9.1
AGS2-W09|9.1 1661054400000 1661057999999 1 492787 9.1
AGS2-W09|9.1 1661050800000 1661054399999 18 338367 9.1
AGS2-W09|9.1 1661050800000 1661054399999 17 338361 9.1
AGS2-W09|9.1 1661050800000 1661054399999 16 338358 9.1
AGS2-W09|9.1 1661050800000 1661054399999 15 338028 9.1
AGS2-W09|9.1 1661050800000 1661054399999 14 338023 9.1
338020 9.1 1661054399999 13
-------------- --------------- --------------- ---------- ---------- --------------- ------------
10.97.152.110:6527/demo_db> select * from __PRE_AGG_DB.pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver limit 100;
----------------- --------------- --------------- ---------- ---------- --------------- ------------
key ts_start ts_end num_rows agg_val binlog_offset filter_key
----------------- --------------- --------------- ---------- ---------- --------------- ------------
12.0.6.303|11.0 1661144400000 1661147999999 613 e 4022612 11.0
12.0.6.303|11.0 1661140800000 1661144399999 656 3687106 11.0
12.0.6.303|11.0 1661137200000 1661140799999 661 4264857 11.0
12.0.6.303|11.0 1661137200000 1661140799999 660 4264847 11.0
12.0.6.303|11.0 1661137200000 1661140799999 659 4264837 11.0
12.0.6.303|11.0 1661137200000 1661140799999 658 4263939 11.0
12.0.6.303|11.0 1661137200000 1661140799999 657 4263929 11.0
12.0.6.303|11.0 1661137200000 1661140799999 656 4263619 11.0
12.0.6.303|11.0 1661137200000 1661140799999 655 4263054 11.0
12.0.6.303|11.0 1661137200000 1661140799999 654 4263045 11.0
12.0.6.303|11.0 1661137200000 1661140799999 653 4263037 11.0
12.0.6.303|11.0 1661137200000 1661140799999 652 4262972 11.0
12.0.6.303|11.0 1661137200000 1661140799999 651 4262963 11.0
12.0.6.303|11.0 1661137200000 1661140799999 650 4262953 11.0
12.0.6.303|11.0 1661137200000 1661140799999 649 4262753 11.0
12.0.6.303|11.0 1661137200000 1661140799999 648 4262360 11.0
12.0.6.303|11.0 1661137200000 1661140799999 647 4262348 11.0
12.0.6.303|11.0 1661137200000 1661140799999 646 4262339 11.0
12.0.6.303|11.0 1661137200000 1661140799999 645 4261865 11.0
12.0.6.303|11.0 1661137200000 1661140799999 644 4261856 11.0
12.0.6.303|11.0 1661137200000 1661140799999 643 4261846 11.0
12.0.6.303|11.0 1661137200000 1661140799999 642 4261754 11.0
12.0.6.303|11.0 1661137200000 1661140799999 641 4261743 11.0
12.0.6.303|11.0 1661137200000 1661140799999 640 4261732 11.0
12.0.6.303|11.0 1661137200000 1661140799999 639 4261720 11.0
12.0.6.303|11.0 1661137200000 1661140799999 638 ~ 4261661 11.0
12.0.6.303|11.0 1661137200000 1661140799999 637 } 4261651 11.0
12.0.6.303|11.0 1661137200000 1661140799999 636 | 4261642 11.0
12.0.6.303|11.0 1661137200000 1661140799999 635 { 4261531 11.0
12.0.6.303|11.0 1661137200000 1661140799999 634 z 4261522 11.0
12.0.6.303|11.0 1661137200000 1661140799999 633 y 4261512 11.0
12.0.6.303|11.0 1661137200000 1661140799999 632 x 4261417 11.0
12.0.6.303|11.0 1661137200000 1661140799999 631 w 4260240 11.0
12.0.6.303|11.0 1661137200000 1661140799999 630 v 4258133 11.0
12.0.6.303|11.0 1661137200000 1661140799999 629 u 4258123 11.0
12.0.6.303|11.0 1661137200000 1661140799999 628 t 4258112 11.0
12.0.6.303|11.0 1661137200000 1661140799999 627 s 4258101 11.0
12.0.6.303|11.0 1661137200000 1661140799999 626 r 4258091 11.0
12.0.6.303|11.0 1661137200000 1661140799999 625 q 4258081 11.0
12.0.6.303|11.0 1661137200000 1661140799999 624 p 4256559 11.0
12.0.6.303|11.0 1661137200000 1661140799999 623 o 4256549 11.0
12.0.6.303|11.0 1661137200000 1661140799999 622 n 4256494 11.0
12.0.6.303|11.0 1661137200000 1661140799999 621 m 4256383 11.0
12.0.6.303|11.0 1661137200000 1661140799999 620 l 4255791 11.0
12.0.6.303|11.0 1661137200000 1661140799999 619 k 4255779 11.0
12.0.6.303|11.0 1661137200000 1661140799999 618 j 4255767 11.0
12.0.6.303|11.0 1661137200000 1661140799999 617 i 4255612 11.0
12.0.6.303|11.0 1661137200000 1661140799999 616 h 4255599 11.0
12.0.6.303|11.0 1661137200000 1661140799999 615 g 4255590 11.0
12.0.6.303|11.0 1661137200000 1661140799999 614 f 4255579 11.0
12.0.6.303|11.0 1661137200000 1661140799999 613 e 4255568 11.0
12.0.6.303|11.0 1661137200000 1661140799999 612 d 4255557 11.0
12.0.6.303|11.0 1661137200000 1661140799999 611 c 4254963 11.0
12.0.6.303|11.0 1661137200000 1661140799999 610 b 4254952 11.0
12.0.6.303|11.0 1661137200000 1661140799999 609 a 4254362 11.0
12.0.6.303|11.0 1661137200000 1661140799999 608 ` 4251794 11.0
12.0.6.303|11.0 1661137200000 1661140799999 607 _ 4249564 11.0
12.0.6.303|11.0 1661137200000 1661140799999 606 ^ 4249010 11.0
12.0.6.303|11.0 1661137200000 1661140799999 605 ] 4248999 11.0
12.0.6.303|11.0 1661137200000 1661140799999 604 \ 4248990 11.0
12.0.6.303|11.0 1661137200000 1661140799999 603 [ 4248445 11.0
12.0.6.303|11.0 1661137200000 1661140799999 602 Z 4248433 11.0
12.0.6.303|11.0 1661137200000 1661140799999 601 Y 4248423 11.0
12.0.6.303|11.0 1661137200000 1661140799999 600 X 4248323 11.0
12.0.6.303|11.0 1661137200000 1661140799999 599 W 4248311 11.0
12.0.6.303|11.0 1661137200000 1661140799999 598 V 4248229 11.0
12.0.6.303|11.0 1661137200000 1661140799999 597 U 4248120 11.0
12.0.6.303|11.0 1661137200000 1661140799999 596 T 4246453 11.0
12.0.6.303|11.0 1661137200000 1661140799999 595 S 4246443 11.0
12.0.6.303|11.0 1661137200000 1661140799999 594 R 4246431 11.0
12.0.6.303|11.0 1661137200000 1661140799999 593 Q 4246085 11.0
12.0.6.303|11.0 1661137200000 1661140799999 592 P 4246040 11.0
12.0.6.303|11.0 1661137200000 1661140799999 591 O 4246029 11.0
12.0.6.303|11.0 1661137200000 1661140799999 590 N 4246019 11.0
12.0.6.303|11.0 1661137200000 1661140799999 589 M 4245957 11.0
12.0.6.303|11.0 1661137200000 1661140799999 588 L 4245946 11.0
12.0.6.303|11.0 1661137200000 1661140799999 587 K 4245933 11.0
12.0.6.303|11.0 1661137200000 1661140799999 586 J 4245697 11.0
12.0.6.303|11.0 1661137200000 1661140799999 585 I 4245686 11.0
12.0.6.303|11.0 1661137200000 1661140799999 584 H 4245674 11.0
12.0.6.303|11.0 1661137200000 1661140799999 583 G 4245652 11.0
12.0.6.303|11.0 1661137200000 1661140799999 582 F 4245642 11.0
12.0.6.303|11.0 1661137200000 1661140799999 581 E 4245603 11.0
12.0.6.303|11.0 1661137200000 1661140799999 580 D 4245591 11.0
12.0.6.303|11.0 1661137200000 1661140799999 579 C 4245581 11.0
12.0.6.303|11.0 1661137200000 1661140799999 578 B 4245542 11.0
12.0.6.303|11.0 1661137200000 1661140799999 577 A 4245456 11.0
12.0.6.303|11.0 1661137200000 1661140799999 576 @ 4245445 11.0
12.0.6.303|11.0 1661137200000 1661140799999 575 ? 4245260 11.0
12.0.6.303|11.0 1661137200000 1661140799999 574 > 4245250 11.0
12.0.6.303|11.0 1661137200000 1661140799999 573 = 4245239 11.0
12.0.6.303|11.0 1661137200000 1661140799999 572 < 4244737 11.0
12.0.6.303|11.0 1661137200000 1661140799999 571 ; 4244726 11.0
12.0.6.303|11.0 1661137200000 1661140799999 570 : 4243642 11.0
12.0.6.303|11.0 1661137200000 1661140799999 569 9 4242843 11.0
12.0.6.303|11.0 1661137200000 1661140799999 568 8 4242638 11.0
12.0.6.303|11.0 1661137200000 1661140799999 567 7 4242627 11.0
12.0.6.303|11.0 1661137200000 1661140799999 566 6 4242617 11.0
12.0.6.303|11.0 1661137200000 1661140799999 565 5 4242017 11.0
12.0.6.303|11.0 1661137200000 1661140799999 564 4 4242005 11.0
----------------- --------------- --------------- ---------- ---------- --------------- ------------
10.97.152.110:6527 > use __PRE_AGG_DB
Use database: __PRE_AGG_DB
10.97.152.110:6527 __PRE_AGG_DB> showtable
name tid pid endpoint role is_alive offset record_cnt memused diskused
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.110:9527 leader yes 996739 996739 115.520 M 113.020 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.190:9527 follower yes 996739 996739 115.520 M 113.017 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 0 10.97.152.199:9527 follower yes 996739 996739 115.520 M 113.017 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.110:9527 follower yes 1063713 1063713 123.130 M 120.340 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.190:9527 leader yes 1063713 1063713 123.130 M 120.342 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 1 10.97.152.199:9527 follower yes 1063713 1063713 123.130 M 120.340 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.110:9527 follower yes 561861 561861 65.056 M 63.659 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.190:9527 follower yes 561861 561861 65.056 M 63.659 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 2 10.97.152.199:9527 leader yes 561861 561861 65.056 M 63.661 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.110:9527 leader yes 1167625 1167625 135.064 M 131.929 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.190:9527 follower yes 1167625 1167625 135.064 M 131.927 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 3 10.97.152.199:9527 follower yes 1167625 1167625 135.064 M 131.927 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.110:9527 follower yes 1004720 1004720 116.329 M 113.750 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.190:9527 leader yes 1004720 1004720 116.329 M 113.752 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 4 10.97.152.199:9527 follower yes 1004720 1004720 116.329 M 113.750 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.110:9527 follower yes 812624 812624 93.666 M 91.045 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.190:9527 follower yes 812624 812624 93.666 M 91.045 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 5 10.97.152.199:9527 leader yes 812624 812624 93.666 M 91.047 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.110:9527 leader yes 1346324 1346324 155.360 M 151.457 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.190:9527 follower yes 1346324 1346324 155.360 M 151.455 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 6 10.97.152.199:9527 follower yes 1346324 1346324 155.360 M 151.455 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.110:9527 follower yes 1343502 1343502 154.800 M 150.644 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.190:9527 leader yes 1343502 1343502 154.800 M 150.646 M
pre_demo_db_demo8option1d_ab_w10d_count_where_device_name_emui_ver 7 7 10.97.152.199:9527 follower yes 1343502 1343502 154.800 M 150.644 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.110:9527 leader yes 1173769 1173769 137.114 M 137.596 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.190:9527 follower yes 1173769 1173769 137.114 M 137.594 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 0 10.97.152.199:9527 follower yes 1173769 1173769 137.114 M 137.594 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.110:9527 follower yes 2856969 2856969 336.806 M 341.825 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.190:9527 leader yes 2856969 2856969 336.806 M 341.827 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 1 10.97.152.199:9527 follower yes 2856969 2856969 336.806 M 341.825 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.110:9527 follower yes 52279 52279 6.163 M 6.228 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.190:9527 follower yes 52279 52279 6.163 M 6.228 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 2 10.97.152.199:9527 leader yes 52279 52279 6.163 M 6.230 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.110:9527 leader yes 1918317 1918317 226.087 M 228.875 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.190:9527 follower yes 1918317 1918317 226.087 M 228.873 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 3 10.97.152.199:9527 follower yes 1918317 1918317 226.087 M 228.873 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.110:9527 follower yes 1375130 1375130 160.798 M 161.549 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.190:9527 leader yes 1375130 1375130 160.798 M 161.551 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 4 10.97.152.199:9527 follower yes 1375130 1375130 160.798 M 161.549 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.110:9527 follower yes 840034 840034 98.067 M 98.331 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.190:9527 follower yes 840034 840034 98.067 M 98.331 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 5 10.97.152.199:9527 leader yes 840034 840034 98.067 M 98.333 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.110:9527 leader yes 58279 58279 6.814 M 6.829 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.190:9527 follower yes 58279 58279 6.814 M 6.826 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 6 10.97.152.199:9527 follower yes 58279 58279 6.814 M 6.826 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.110:9527 follower yes 33909 33909 3.944 M 3.925 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.190:9527 leader yes 33909 33909 3.944 M 3.927 M
pre_demo_db_demo8option1d_cat_w10d_count_where_app_ver_emui_ver 8 7 10.97.152.199:9527 follower yes 33909 33909 3.944 M 3.925 M