search

wangqiim / polardb-final

2 stars 0 forks source link

op #1

Closed wangqiim closed 2 years ago

wangqiim commented 2 years ago
  1. ~尝试单个concurrent_unorderer_map代替50个~

    ~卡死，不知为啥~

~2. 尝试减低每次vector,string的分配开销,不使用rest_rpc，改用socket~

~出错，不知为啥~

  1. ~blizzardUserId~

    ~没提升，应该开销都在网络上了，没有提升~

  2. ~尝试读写锁更小的粒度（比如150个读写锁)~

2022/09/21

  1. 考虑默认need_peers_send ={false, false, false}，如果未命中，则广播一次兜底。这样可以忽掉send_write同步完成的sleep开销。 好处 1. 在写完之前，有多余的salary广播。2. 不用等到所有的cache都同步完成（sleep)，即可进入读性能阶段。
  2. 考虑把get_pos_from_index的vector给优化掉。（统计一下vector的最大长度）
wangqiim commented 2 years ago

baseline score 1078.36 https://github.com/wangqiim/polardb-final/commit/1e11774f760555520f6a245a1d4f83985745411f

wangqiim commented 2 years ago

[2022-09-05 16:41:52.082] [info] Server local get pk 120066321 [2022-09-05 16:41:52.082] [info] Server local get uk 39972732 [2022-09-05 16:41:52.082] [info] Server local get sk 39961437 [2022-09-05 16:41:52.082] [info] Server remote get pk 9263585 [2022-09-05 16:41:52.082] [info] Server remote get uk 3071575 [2022-09-05 16:41:52.082] [info] Server remote get sk 39961437

wangqiim commented 2 years ago

写完2亿条数据之前，混杂的读数量 1662447309332_A7E8B7B9-18B5-4110-939F-0A18B9F82944

wangqiim commented 2 years ago

性能阶段单个节点write数据分布和read请求类型

[2022-09-06 13:51:56.475] [info] ------ log local read type -------- (重复的应该是local和remote)
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 0, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 0, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 1, count: 23967880
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 1, count: 1765214
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 3, count: 31986613
[2022-09-06 13:51:56.475] [info] Server local get select_column: 0, where_column: 3, count: 31986613
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 0, count: 19974391
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 0, count: 1465365
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 1, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 1, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 3, count: 4014032
[2022-09-06 13:51:56.475] [info] Server local get select_column: 1, where_column: 3, count: 4014032
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 0, count: 19995033
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 0, count: 1473546
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 1, count: 8023407
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 1, count: 583195
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 3, count: 4003519
[2022-09-06 13:51:56.475] [info] Server local get select_column: 2, where_column: 3, count: 4003519
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 0, count: 80033420
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 0, count: 5889048
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 1, count: 8002195
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 1, count: 586667
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 2, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 3, count: 0
[2022-09-06 13:51:56.475] [info] Server local get select_column: 3, where_column: 3, count: 0
[2022-09-06 13:51:56.475] [info] ------ log local write max/min pk/sk -------
[2022-09-06 13:51:56.475] [info] local_write_max_pk[0] = 797077569
[2022-09-06 13:51:56.475] [info] local_write_min_pk[0] = 600000000
[2022-09-06 13:51:56.475] [info] local_write_max_sk[0] = 3423580005592614631
[2022-09-06 13:51:56.475] [info] local_write_min_sk[0] = 2576903559355698679
[2022-09-06 13:51:56.475] [info] local_write_max_pk[1] = 789577349
[2022-09-06 13:51:56.475] [info] local_write_min_pk[1] = 600000010
[2022-09-06 13:51:56.475] [info] local_write_max_sk[1] = 3391210492777985803
[2022-09-06 13:51:56.475] [info] local_write_min_sk[1] = 2576903805587626825
[2022-09-06 13:51:56.475] [info] local_write_max_pk[2] = 786125709
[2022-09-06 13:51:56.475] [info] local_write_min_pk[2] = 600000020
[2022-09-06 13:51:56.475] [info] local_write_max_sk[2] = 3376573752841913751
[2022-09-06 13:51:56.475] [info] local_write_min_sk[2] = 2576903646989056603
[2022-09-06 13:51:56.475] [info] local_write_max_pk[3] = 795349089
[2022-09-06 13:51:56.475] [info] local_write_min_pk[3] = 600000030
[2022-09-06 13:51:56.475] [info] local_write_max_sk[3] = 3416261607882731781
[2022-09-06 13:51:56.475] [info] local_write_min_sk[3] = 2576903413107950667
[2022-09-06 13:51:56.475] [info] local_write_max_pk[4] = 799999999
[2022-09-06 13:51:56.475] [info] local_write_min_pk[4] = 600000090
[2022-09-06 13:51:56.475] [info] local_write_max_sk[4] = 3436246425497047757
[2022-09-06 13:51:56.475] [info] local_write_min_sk[4] = 2576904997842943544
[2022-09-06 13:51:56.475] [info] local_write_max_pk[5] = 789418359
[2022-09-06 13:51:56.475] [info] local_write_min_pk[5] = 600000110
[2022-09-06 13:51:56.475] [info] local_write_max_sk[5] = 3390647434219685513
[2022-09-06 13:51:56.475] [info] local_write_min_sk[5] = 2576903617088396522
[2022-09-06 13:51:56.475] [info] local_write_max_pk[6] = 799967349
[2022-09-06 13:51:56.475] [info] local_write_min_pk[6] = 600000150
[2022-09-06 13:51:56.475] [info] local_write_max_sk[6] = 3435963827492715799
[2022-09-06 13:51:56.475] [info] local_write_min_sk[6] = 2576904873660017057
[2022-09-06 13:51:56.475] [info] local_write_max_pk[7] = 791077319
[2022-09-06 13:51:56.475] [info] local_write_min_pk[7] = 600000170
[2022-09-06 13:51:56.475] [info] local_write_max_sk[7] = 3397684407700176437
[2022-09-06 13:51:56.475] [info] local_write_min_sk[7] = 2576905474894358464
[2022-09-06 13:51:56.475] [info] local_write_max_pk[8] = 799536719
[2022-09-06 13:51:56.475] [info] local_write_min_pk[8] = 600000200
[2022-09-06 13:51:56.475] [info] local_write_max_sk[8] = 3433994624350005213
[2022-09-06 13:51:56.475] [info] local_write_min_sk[8] = 2576903709832419123
[2022-09-06 13:51:56.475] [info] local_write_max_pk[9] = 799967639
[2022-09-06 13:51:56.475] [info] local_write_min_pk[9] = 600000250
[2022-09-06 13:51:56.475] [info] local_write_max_sk[9] = 3435964110977308448
[2022-09-06 13:51:56.475] [info] local_write_min_sk[9] = 2576905019368857629
[2022-09-06 13:51:56.475] [info] local_write_max_pk[10] = 798747569
[2022-09-06 13:51:56.475] [info] local_write_min_pk[10] = 600000260
[2022-09-06 13:51:56.475] [info] local_write_max_sk[10] = 3430616961623992807
[2022-09-06 13:51:56.475] [info] local_write_min_sk[10] = 2576903993048713032
[2022-09-06 13:51:56.475] [info] local_write_max_pk[11] = 797567609
[2022-09-06 13:51:56.475] [info] local_write_min_pk[11] = 600000270
[2022-09-06 13:51:56.475] [info] local_write_max_sk[11] = 3425550311137318651
[2022-09-06 13:51:56.475] [info] local_write_min_sk[11] = 2576903448627565258
[2022-09-06 13:51:56.475] [info] local_write_max_pk[12] = 797282199
[2022-09-06 13:51:56.475] [info] local_write_min_pk[12] = 600000330
[2022-09-06 13:51:56.475] [info] local_write_max_sk[12] = 3424424444066090967
[2022-09-06 13:51:56.475] [info] local_write_min_sk[12] = 2576903444360523392
[2022-09-06 13:51:56.475] [info] local_write_max_pk[13] = 796368259
[2022-09-06 13:51:56.475] [info] local_write_min_pk[13] = 600000340
[2022-09-06 13:51:56.475] [info] local_write_max_sk[13] = 3420483842220234042
[2022-09-06 13:51:56.475] [info] local_write_min_sk[13] = 2576903771307161894
[2022-09-06 13:51:56.475] [info] local_write_max_pk[14] = 793791899
[2022-09-06 13:51:56.475] [info] local_write_min_pk[14] = 600000510
[2022-09-06 13:51:56.475] [info] local_write_max_sk[14] = 3409506079524596400
[2022-09-06 13:51:56.475] [info] local_write_min_sk[14] = 2576903414313873573
[2022-09-06 13:51:56.475] [info] local_write_max_pk[15] = 798082819
[2022-09-06 13:51:56.475] [info] local_write_min_pk[15] = 600000680
[2022-09-06 13:51:56.475] [info] local_write_max_sk[15] = 3427802228481734838
[2022-09-06 13:51:56.475] [info] local_write_min_sk[15] = 2576903424127772956
[2022-09-06 13:51:56.475] [info] local_write_max_pk[16] = 799999949
[2022-09-06 13:51:56.475] [info] local_write_min_pk[16] = 600000920
[2022-09-06 13:51:56.475] [info] local_write_max_sk[16] = 3436244458464795285
[2022-09-06 13:51:56.475] [info] local_write_min_sk[16] = 2576903745616265650
[2022-09-06 13:51:56.475] [info] local_write_max_pk[17] = 799966989
[2022-09-06 13:51:56.475] [info] local_write_min_pk[17] = 600001200
[2022-09-06 13:51:56.475] [info] local_write_max_sk[17] = 3435964998513766098
[2022-09-06 13:51:56.475] [info] local_write_min_sk[17] = 2576904282102694577
[2022-09-06 13:51:56.475] [info] local_write_max_pk[18] = 799966869
[2022-09-06 13:51:56.475] [info] local_write_min_pk[18] = 600001360
[2022-09-06 13:51:56.475] [info] local_write_max_sk[18] = 3435964852668606318
[2022-09-06 13:51:56.475] [info] local_write_min_sk[18] = 2576903582674501253
[2022-09-06 13:51:56.475] [info] local_write_max_pk[19] = 795973159
[2022-09-06 13:51:56.475] [info] local_write_min_pk[19] = 600001560
[2022-09-06 13:51:56.475] [info] local_write_max_sk[19] = 3418794992231307393
[2022-09-06 13:51:56.475] [info] local_write_min_sk[19] = 2576903535592198536
[2022-09-06 13:51:56.475] [info] local_write_max_pk[20] = 796280679
[2022-09-06 13:51:56.475] [info] local_write_min_pk[20] = 600001970
[2022-09-06 13:51:56.475] [info] local_write_max_sk[20] = 3420202335207775881
[2022-09-06 13:51:56.475] [info] local_write_min_sk[20] = 2576903725115082286
[2022-09-06 13:51:56.475] [info] local_write_max_pk[21] = 798443199
[2022-09-06 13:51:56.475] [info] local_write_min_pk[21] = 600001980
[2022-09-06 13:51:56.475] [info] local_write_max_sk[21] = 3429491078471283981
[2022-09-06 13:51:56.475] [info] local_write_min_sk[21] = 2576903487420183675
[2022-09-06 13:51:56.475] [info] local_write_max_pk[22] = 799999979
[2022-09-06 13:51:56.475] [info] local_write_min_pk[22] = 600002040
[2022-09-06 13:51:56.475] [info] local_write_max_sk[22] = 3436245794261598857
[2022-09-06 13:51:56.475] [info] local_write_min_sk[22] = 2576912806494461595
[2022-09-06 13:51:56.475] [info] local_write_max_pk[23] = 799927359
[2022-09-06 13:51:56.475] [info] local_write_min_pk[23] = 600002110
[2022-09-06 13:51:56.475] [info] local_write_max_sk[23] = 3435683457673008355
[2022-09-06 13:51:56.475] [info] local_write_min_sk[23] = 2576903826966737988
[2022-09-06 13:51:56.475] [info] local_write_max_pk[24] = 799967319
[2022-09-06 13:51:56.475] [info] local_write_min_pk[24] = 600004050
[2022-09-06 13:51:56.475] [info] local_write_max_sk[24] = 3435964977057050871
[2022-09-06 13:51:56.475] [info] local_write_min_sk[24] = 2576911032633741625
[2022-09-06 13:51:56.475] [info] local_write_max_pk[25] = 799967469
[2022-09-06 13:51:56.475] [info] local_write_min_pk[25] = 600004160
[2022-09-06 13:51:56.475] [info] local_write_max_sk[25] = 3435963118858614696
[2022-09-06 13:51:56.475] [info] local_write_min_sk[25] = 2576904411304856333
[2022-09-06 13:51:56.475] [info] local_write_max_pk[26] = 797307969
[2022-09-06 13:51:56.475] [info] local_write_min_pk[26] = 600004630
[2022-09-06 13:51:56.475] [info] local_write_max_sk[26] = 3424424490358516260
[2022-09-06 13:51:56.475] [info] local_write_min_sk[26] = 2576903471276332374
[2022-09-06 13:51:56.475] [info] local_write_max_pk[27] = 799967059
[2022-09-06 13:51:56.475] [info] local_write_min_pk[27] = 600005190
[2022-09-06 13:51:56.475] [info] local_write_max_sk[27] = 3435964938196276806
[2022-09-06 13:51:56.475] [info] local_write_min_sk[27] = 2576907931606311169
[2022-09-06 13:51:56.475] [info] local_write_max_pk[28] = 789257299
[2022-09-06 13:51:56.475] [info] local_write_min_pk[28] = 600005940
[2022-09-06 13:51:56.475] [info] local_write_max_sk[28] = 3390084409471685523
[2022-09-06 13:51:56.475] [info] local_write_min_sk[28] = 2576904260655529723
[2022-09-06 13:51:56.475] [info] local_write_max_pk[29] = 796958099
[2022-09-06 13:51:56.475] [info] local_write_min_pk[29] = 600006030
[2022-09-06 13:51:56.475] [info] local_write_max_sk[29] = 3423017175817515257
[2022-09-06 13:51:56.475] [info] local_write_min_sk[29] = 2576903819714518229
[2022-09-06 13:51:56.475] [info] local_write_max_pk[30] = 799967729
[2022-09-06 13:51:56.475] [info] local_write_min_pk[30] = 600006040
[2022-09-06 13:51:56.475] [info] local_write_max_sk[30] = 3435965032793443517
[2022-09-06 13:51:56.475] [info] local_write_min_sk[30] = 2576910050239799861
[2022-09-06 13:51:56.475] [info] local_write_max_pk[31] = 798314519
[2022-09-06 13:51:56.475] [info] local_write_min_pk[31] = 600006160
[2022-09-06 13:51:56.475] [info] local_write_max_sk[31] = 3428927917752841957
[2022-09-06 13:51:56.475] [info] local_write_min_sk[31] = 2576904736286666048
[2022-09-06 13:51:56.475] [info] local_write_max_pk[32] = 799999939
[2022-09-06 13:51:56.475] [info] local_write_min_pk[32] = 600006170
[2022-09-06 13:51:56.475] [info] local_write_max_sk[32] = 3436243913018413278
[2022-09-06 13:51:56.475] [info] local_write_min_sk[32] = 2576918445750709904
[2022-09-06 13:51:56.475] [info] local_write_max_pk[33] = 793298529
[2022-09-06 13:51:56.475] [info] local_write_min_pk[33] = 600006210
[2022-09-06 13:51:56.475] [info] local_write_max_sk[33] = 3407254458061471508
[2022-09-06 13:51:56.475] [info] local_write_min_sk[33] = 2576903458407320435
[2022-09-06 13:51:56.475] [info] local_write_max_pk[34] = 799497569
[2022-09-06 13:51:56.475] [info] local_write_min_pk[34] = 600006220
[2022-09-06 13:51:56.475] [info] local_write_max_sk[34] = 3433993883991628211
[2022-09-06 13:51:56.475] [info] local_write_min_sk[34] = 2576903681403738164
[2022-09-06 13:51:56.475] [info] local_write_max_pk[35] = 799619349
[2022-09-06 13:51:56.475] [info] local_write_min_pk[35] = 600006230
[2022-09-06 13:51:56.475] [info] local_write_max_sk[35] = 3434557640367119272
[2022-09-06 13:51:56.475] [info] local_write_min_sk[35] = 2576904449964338620
[2022-09-06 13:51:56.475] [info] local_write_max_pk[36] = 797967339
[2022-09-06 13:51:56.475] [info] local_write_min_pk[36] = 600006270
[2022-09-06 13:51:56.475] [info] local_write_max_sk[36] = 3427520061269223591
[2022-09-06 13:51:56.475] [info] local_write_min_sk[36] = 2576903521733613076
[2022-09-06 13:51:56.475] [info] local_write_max_pk[37] = 799408619
[2022-09-06 13:51:56.475] [info] local_write_min_pk[37] = 600006960
[2022-09-06 13:51:56.475] [info] local_write_max_sk[37] = 3433710672503139965
[2022-09-06 13:51:56.475] [info] local_write_min_sk[37] = 2576905454452145187
[2022-09-06 13:51:56.475] [info] local_write_max_pk[38] = 798658249
[2022-09-06 13:51:56.475] [info] local_write_min_pk[38] = 600007280
[2022-09-06 13:51:56.475] [info] local_write_max_sk[38] = 3430335504341365577
[2022-09-06 13:51:56.475] [info] local_write_min_sk[38] = 2576972201634421435
[2022-09-06 13:51:56.475] [info] local_write_max_pk[39] = 794115239
[2022-09-06 13:51:56.475] [info] local_write_min_pk[39] = 600007460
[2022-09-06 13:51:56.475] [info] local_write_max_sk[39] = 3410913304667841718
[2022-09-06 13:51:56.475] [info] local_write_min_sk[39] = 2576910238152419315
[2022-09-06 13:51:56.475] [info] local_write_max_pk[40] = 797230849
[2022-09-06 13:51:56.475] [info] local_write_min_pk[40] = 600007980
[2022-09-06 13:51:56.475] [info] local_write_max_sk[40] = 3424143085271713574
[2022-09-06 13:51:56.475] [info] local_write_min_sk[40] = 2576903436962510649
[2022-09-06 13:51:56.475] [info] local_write_max_pk[41] = 799966879
[2022-09-06 13:51:56.475] [info] local_write_min_pk[41] = 600008020
[2022-09-06 13:51:56.475] [info] local_write_max_sk[41] = 3435964947976556543
[2022-09-06 13:51:56.475] [info] local_write_min_sk[41] = 2576919117280266993
[2022-09-06 13:51:56.476] [info] local_write_max_pk[42] = 799967739
[2022-09-06 13:51:56.476] [info] local_write_min_pk[42] = 600022800
[2022-09-06 13:51:56.476] [info] local_write_max_sk[42] = 3435963926314130342
[2022-09-06 13:51:56.476] [info] local_write_min_sk[42] = 2576903508944530014
[2022-09-06 13:51:56.476] [info] local_write_max_pk[43] = 799999959
[2022-09-06 13:51:56.476] [info] local_write_min_pk[43] = 600023330
[2022-09-06 13:51:56.476] [info] local_write_max_sk[43] = 3436246429839428840
[2022-09-06 13:51:56.476] [info] local_write_min_sk[43] = 2576906086691126422
[2022-09-06 13:51:56.476] [info] local_write_max_pk[44] = 799967139
[2022-09-06 13:51:56.476] [info] local_write_min_pk[44] = 600023690
[2022-09-06 13:51:56.476] [info] local_write_max_sk[44] = 3435965011370742424
[2022-09-06 13:51:56.476] [info] local_write_min_sk[44] = 2576908121797575241
[2022-09-06 13:51:56.476] [info] local_write_max_pk[45] = 799642929
[2022-09-06 13:51:56.476] [info] local_write_min_pk[45] = 600028840
[2022-09-06 13:51:56.476] [info] local_write_max_sk[45] = 3434557663015787572
[2022-09-06 13:51:56.476] [info] local_write_min_sk[45] = 2576912112159916478
[2022-09-06 13:51:56.476] [info] local_write_max_pk[46] = 797996099
[2022-09-06 13:51:56.476] [info] local_write_min_pk[46] = 600028990
[2022-09-06 13:51:56.476] [info] local_write_max_sk[46] = 3427520526610757315
[2022-09-06 13:51:56.476] [info] local_write_min_sk[46] = 2576916252517673601
[2022-09-06 13:51:56.476] [info] local_write_max_pk[47] = 799999969
[2022-09-06 13:51:56.476] [info] local_write_min_pk[47] = 600029330
[2022-09-06 13:51:56.476] [info] local_write_max_sk[47] = 3436244978201061566
[2022-09-06 13:51:56.476] [info] local_write_min_sk[47] = 2576911437881658113
[2022-09-06 13:51:56.476] [info] local_write_max_pk[48] = 799999989
[2022-09-06 13:51:56.476] [info] local_write_min_pk[48] = 600061820
[2022-09-06 13:51:56.476] [info] local_write_max_sk[48] = 3436244943786691281
[2022-09-06 13:51:56.476] [info] local_write_min_sk[48] = 2577184916380925449
[2022-09-06 13:51:56.476] [info] local_write_max_pk[49] = 799999929
[2022-09-06 13:51:56.476] [info] local_write_min_pk[49] = 600063560
[2022-09-06 13:51:56.476] [info] local_write_max_sk[49] = 3436245824275291308
[2022-09-06 13:51:56.476] [info] local_write_min_sk[49] = 2577190761985822744
[2022-09-06 13:51:56.476] [info] total_local_write_max_pk = 799999999
[2022-09-06 13:51:56.476] [info] total_local_write_min_pk = 600000000
[2022-09-06 13:51:56.476] [info] total_local_write_max_sk = 3436246429839428840
[2022-09-06 13:51:56.476] [info] total_local_write_min_sk = 2576903413107950667
[2022-09-06 13:51:56.476] [info] --------log local read max/min pk/sk----------------
[2022-09-06 13:51:56.476] [info] local_read_max_pk[0] = 0
[2022-09-06 13:51:56.476] [info] local_read_min_pk[0] = 18446744073709551615
[2022-09-06 13:51:56.476] [info] local_read_max_sk[0] = 0
[2022-09-06 13:51:56.476] [info] local_read_min_sk[0] = 18446744073709551615
[2022-09-06 13:51:56.476] [info] local_read_max_pk[1] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[1] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[1] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[1] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[2] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[2] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[2] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[2] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[3] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[3] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[3] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[3] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[4] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[4] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[4] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[4] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[5] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[5] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[5] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[5] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[6] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[6] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[6] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[6] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[7] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[7] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[7] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[7] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[8] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[8] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[8] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[8] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[9] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[9] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[9] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[9] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[10] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[10] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[10] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[10] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[11] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[11] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[11] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[11] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[12] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[12] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[12] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[12] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[13] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[13] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[13] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[13] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[14] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[14] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[14] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[14] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[15] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[15] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[15] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[15] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[16] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[16] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[16] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[16] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[17] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[17] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[17] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[17] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[18] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[18] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[18] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[18] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[19] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[19] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[19] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[19] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[20] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[20] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[20] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[20] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[21] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[21] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[21] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[21] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[22] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[22] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[22] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[22] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[23] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[23] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[23] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[23] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[24] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[24] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[24] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[24] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[25] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[25] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[25] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[25] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[26] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[26] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[26] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[26] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[27] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[27] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[27] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[27] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[28] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[28] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[28] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[28] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[29] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[29] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[29] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[29] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[30] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[30] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[30] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[30] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[31] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[31] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[31] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[31] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[32] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[32] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[32] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[32] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[33] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[33] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[33] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[33] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[34] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[34] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[34] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[34] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[35] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[35] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[35] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[35] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[36] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[36] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[36] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[36] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[37] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[37] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[37] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[37] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[38] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[38] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[38] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[38] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[39] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[39] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[39] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[39] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[40] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[40] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[40] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[40] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[41] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[41] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[41] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[41] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[42] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[42] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[42] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[42] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[43] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[43] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[43] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[43] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[44] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[44] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[44] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[44] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[45] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[45] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[45] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[45] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[46] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[46] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[46] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[46] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[47] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[47] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[47] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[47] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[48] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[48] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[48] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[48] = 28919528047696
[2022-09-06 13:51:56.476] [info] local_read_max_pk[49] = 799995603
[2022-09-06 13:51:56.476] [info] local_read_min_pk[49] = 1853
[2022-09-06 13:51:56.476] [info] local_read_max_sk[49] = 3435938253330993219
[2022-09-06 13:51:56.476] [info] local_read_min_sk[49] = 28919528047696
[2022-09-06 13:51:56.476] [info] total_local_read_max_pk = 799995603
[2022-09-06 13:51:56.476] [info] total_local_read_min_pk = 1853
[2022-09-06 13:51:56.476] [info] total_local_read_max_sk = 3435938253330993219
[2022-09-06 13:51:56.476] [info] total_local_read_min_sk = 28919528047696
[2022-09-06 13:51:56.476] [info] ------------------------------------------------------
[2022-09-06 13:51:56.476] [info] total_write_cnt = 200000000
wangqiim commented 2 years ago

统计deinit时，各个线程写入的数据范围。 1805342_cpp_run.zip

wangqiim commented 2 years ago

单个节点上的sk列没有重复值。 1805616_cpp_run_2.zip

wangqiim commented 2 years ago

开启过滤 1819052_cpp_run_2.zip