find path 性能还是很不理想

  • nebula 版本:v3.2.0
  • 部署方式:分布式
  • 安装方式:RPM
  • 是否为线上版本:Y
  • 硬件信息
    • 磁盘( 推荐使用 SSD)
    • CPU、内存信息
  • 问题的具体描述
    用了最新版的find path 优化后的版本,做了测试,发现这个find path 性能还是很不理想和neo4j 差了数量级的。
    profile 之后如下:
(root@nebula) [Relation]> profile FIND SHORTEST PATH FROM 6708325840852936710 TO 657274819696178340 OVER Employ, Invest, Legal, Branch, HisEmploy, HisLegal, HisInvest BIDIRECT UPTO 10 Steps yield path as p
+---+
| p |
+---+
+---+
Empty set (time spent 10799860/10796632 us)

Execution Plan (optimize time 55 us)

-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| id | name         | dependencies | profiling data                                                                                                             | operator info                                                                                     |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  7 | DataCollect  | 6            | ver: 0, rows: 0, execTime: 16us, totalTime: 17us                                                                           | outputVar: {                                                                                      |
|    |              |              |                                                                                                                            |   "colNames": [                                                                                   |
|    |              |              |                                                                                                                            |     "p"                                                                                           |
|    |              |              |                                                                                                                            |   ],                                                                                              |
|    |              |              |                                                                                                                            |   "type": "DATASET",                                                                              |
|    |              |              |                                                                                                                            |   "name": "__DataCollect_7"                                                                       |
|    |              |              |                                                                                                                            | }                                                                                                 |
|    |              |              |                                                                                                                            | inputVar: [                                                                                       |
|    |              |              |                                                                                                                            |   {                                                                                               |
|    |              |              |                                                                                                                            |     "colNames": [                                                                                 |
|    |              |              |                                                                                                                            |       "_path"                                                                                     |
|    |              |              |                                                                                                                            |     ],                                                                                            |
|    |              |              |                                                                                                                            |     "type": "DATASET",                                                                            |
|    |              |              |                                                                                                                            |     "name": "__BFSShortest_5"
                                                           |
|    |              |              |                                                                                                                            |   }
                                                           |
|    |              |              |                                                                                                                            | ]
                                                           |
|    |              |              |                                                                                                                            | kind: BFS SHORTEST
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  6 | Loop         | 0            | ver: 0, rows: 1, execTime: 12us, totalTime: 13us                                                                           | outputVar: {
                                                           |
|    |              |              | ver: 1, rows: 1, execTime: 9us, totalTime: 10us                                                                            |   "colNames": [],
                                                           |
|    |              |              | ver: 2, rows: 1, execTime: 9us, totalTime: 10us                                                                            |   "type": "DATASET",
                                                           |
|    |              |              | ver: 3, rows: 1, execTime: 11us, totalTime: 12us                                                                           |   "name": "__Loop_6"
                                                           |
|    |              |              | ver: 4, rows: 1, execTime: 12us, totalTime: 13us                                                                           | }
                                                           |
|    |              |              | ver: 5, rows: 1, execTime: 255256us, totalTime: 255259us                                                                   | inputVar:
                                                           |
|    |              |              |                                                                                                                            | condition: ((++($__VAR_2)<=5) AND (($__BFSShortest_5==__EMPTY__) OR (size($__BFSShortest_5)==0))) |
|    |              |              |                                                                                                                            | loopBody: 5
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  5 | BFSShortest  | 3,4          | ver: 0, rows: 0, execTime: 20us, totalTime: 5781us                                                                         | branch: true, nodeId: 6
                                                           |
|    |              |              | ver: 1, rows: 0, execTime: 12us, totalTime: 17859us                                                                        |
                                                           |
|    |              |              | ver: 2, rows: 0, execTime: 9us, totalTime: 130085us                                                                        | outputVar: {
                                                           |
|    |              |              | ver: 3, rows: 0, execTime: 11us, totalTime: 639233us                                                                       |   "colNames": [
                                                           |
|    |              |              | ver: 4, rows: 0, execTime: 11us, totalTime: 3752116us                                                                      |     "_path"
                                                           |
|    |              |              |                                                                                                                            |   ],
                                                           |
|    |              |              |                                                                                                                            |   "type": "DATASET",
                                                           |
|    |              |              |                                                                                                                            |   "name": "__BFSShortest_5"
                                                           |
|    |              |              |                                                                                                                            | }
                                                           |
|    |              |              |                                                                                                                            | inputVar: {
                                                           |
|    |              |              |                                                                                                                            |   "rightVar": "__GetNeighbors_4",                                                                 |
|    |              |              |                                                                                                                            |   "leftVar": "__GetNeighbors_3"                                                                   |
|    |              |              |                                                                                                                            | }
                                                           |
|    |              |              |                                                                                                                            | LeftNextVidVar: "__VAR_0"
                                                           |
|    |              |              |                                                                                                                            | RightNextVidVar: "__VAR_1"
                                                           |
|    |              |              |                                                                                                                            | steps: 10
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  3 | GetNeighbors | 2            | {                                                                                                                          | outputVar: {
                                                           |
|    |              |              | ver: 0, rows: 4, execTime: 50us, totalTime: 1569us                                                                         |   "colNames": [],
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:697(us),HashJoinNode:689(us),RelNode:697(us),SingleEdgeNode:678(us)}                     |   "type": "DATASET",
                                                           |
|    |              |              | total_rpc_time: 1511(us)                                                                                                   |   "name": "__GetNeighbors_3"
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 995(us)/1464(us)/1,                                                                 | }
                                                           |
|    |              |              | }                                                                                                                          | inputVar: __VAR_0
                                                           |
|    |              |              | {                                                                                                                          | space: 2
                                                           |
|    |              |              | ver: 1, rows: 7, execTime: 46us, totalTime: 1118us                                                                         | dedup: true
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 643(us)/1034(us)/2,                                                                 | limit: -1
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:1014(us),HashJoinNode:1003(us),RelNode:1015(us),SingleEdgeNode:985(us)}                  | filter:
                                                           |
|    |              |              | total_rpc_time: 1066(us)                                                                                                   | orderBy: []
                                                           |
|    |              |              | }                                                                                                                          | src: COLUMN[0]
                                                           |
|    |              |              | {                                                                                                                          | edgeTypes: []
                                                           |
|    |              |              | ver: 2, rows: 4, execTime: 70us, totalTime: 1057us                                                                         | edgeDirection: OUT_EDGE
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:517(us),HashJoinNode:508(us),RelNode:517(us),SingleEdgeNode:497(us)}                     | vertexProps:
                                                           |
|    |              |              | total_rpc_time: 975(us)                                                                                                    | edgeProps: [
                                                           |
|    |              |              | "10.0.7.89":9779 exec/total/vertices: 639(us)/920(us)/1,                                                                   |   {
                                                           |
|    |              |              | }                                                                                                                          |     "props": [
                                                           |
|    |              |              | {                                                                                                                          |       "_dst",
                                                           |
|    |              |              | ver: 3, rows: 5, execTime: 56us, totalTime: 1275us                                                                         |       "_type",
                                                           |
|    |              |              | total_rpc_time: 1208(us)                                                                                                   |       "_rank"
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 708(us)/1155(us)/1,                                                                 |     ],
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:575(us),HashJoinNode:566(us),RelNode:575(us),SingleEdgeNode:559(us)}                     |     "type": -8
                                                           |
|    |              |              | }                                                                                                                          |   },
                                                           |
|    |              |              | {                                                                                                                          |   {
                                                           |
|    |              |              | ver: 4, rows: 8, execTime: 97us, totalTime: 1525us                                                                         |     "props": [
                                                           |
|    |              |              | "10.0.7.93":9779 exec/total/vertices: 779(us)/1294(us)/1,                                                                  |       "_dst",
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:604(us),HashJoinNode:596(us),RelNode:605(us),SingleEdgeNode:585(us)}                     |       "_type",
                                                           |
|    |              |              | total_rpc_time: 1416(us)                                                                                                   |       "_rank"
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 822(us)/1291(us)/1,                                                                 |     ],
                                                           |
|    |              |              | }                                                                                                                          |     "type": -6
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -7
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -9
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -10
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -12
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -11
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 8
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 6
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 7
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 9
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 10
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 12
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 11
                                                           |
|    |              |              |                                                                                                                            |   }
                                                           |
|    |              |              |                                                                                                                            | ]
                                                           |
|    |              |              |                                                                                                                            | statProps:
                                                           |
|    |              |              |                                                                                                                            | exprs:
                                                           |
|    |              |              |                                                                                                                            | random: false
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  2 | PassThrough  | 1            | ver: 0, rows: 0, execTime: 3us, totalTime: 3us                                                                             | outputVar: {
                                                           |
|    |              |              | ver: 1, rows: 0, execTime: 1us, totalTime: 2us                                                                             |   "colNames": [],
                                                           |
|    |              |              | ver: 2, rows: 0, execTime: 4us, totalTime: 5us                                                                             |   "type": "DATASET",
                                                           |
|    |              |              | ver: 3, rows: 0, execTime: 4us, totalTime: 4us                                                                             |   "name": "__PassThrough_2"
                                                           |
|    |              |              | ver: 4, rows: 0, execTime: 3us, totalTime: 4us                                                                             | }
                                                           |
|    |              |              |                                                                                                                            | inputVar: __Start_1
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  1 | Start        |              | ver: 0, rows: 0, execTime: 0us, totalTime: 7us                                                                             | outputVar: {
                                                           |
|    |              |              | ver: 1, rows: 0, execTime: 0us, totalTime: 5us                                                                             |   "colNames": [],
                                                           |
|    |              |              | ver: 2, rows: 0, execTime: 0us, totalTime: 5us                                                                             |   "type": "DATASET",
                                                           |
|    |              |              | ver: 3, rows: 0, execTime: 0us, totalTime: 4us                                                                             |   "name": "__Start_1"
                                                           |
|    |              |              | ver: 4, rows: 0, execTime: 0us, totalTime: 4us                                                                             | }
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  4 | GetNeighbors | 2            | {                                                                                                                          | outputVar: {
                                                           |
|    |              |              | ver: 0, rows: 4024, execTime: 39us, totalTime: 5481us                                                                      |   "colNames": [],
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:2814(us),HashJoinNode:936(us),RelNode:2815(us),SingleEdgeNode:927(us)}                   |   "type": "DATASET",
                                                           |
|    |              |              | total_rpc_time: 5434(us)                                                                                                   |   "name": "__GetNeighbors_4"
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 3162(us)/5388(us)/1,                                                                | }
                                                           |
|    |              |              | }                                                                                                                          | inputVar: __VAR_1
                                                           |
|    |              |              | {                                                                                                                          | space: 2
                                                           |
|    |              |              | ver: 1, rows: 16852, execTime: 7208us, totalTime: 128290us                                                                 | dedup: true
                                                           |
|    |              |              | "10.0.7.93":9779 exec/total/vertices: 69724(us)/79631(us)/628,                                                             | limit: -1
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:373190(us),HashJoinNode:370777(us),RelNode:373280(us),SingleEdgeNode:369557(us)}         | filter:
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 70331(us)/76286(us)/681,                                                            | orderBy: []
                                                           |
|    |              |              | "10.0.7.92":9779 exec/total/vertices: 85122(us)/93837(us)/687,                                                             | src: COLUMN[0]
                                                           |
|    |              |              | "10.0.7.95":9779 exec/total/vertices: 67512(us)/74396(us)/641,                                                             | edgeTypes: []
                                                           |
|    |              |              | "10.0.7.89":9779 exec/total/vertices: 99680(us)/102421(us)/705,                                                            | edgeDirection: OUT_EDGE
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 78735(us)/85103(us)/654,                                                            | vertexProps:
                                                           |
|    |              |              | total_rpc_time: 121068(us)                                                                                                 | edgeProps: [
                                                           |
|    |              |              | }                                                                                                                          |   {
                                                           |
|    |              |              | {                                                                                                                          |     "props": [
                                                           |
|    |              |              | ver: 2, rows: 96408, execTime: 3007us, totalTime: 174999us                                                                 |       "_dst",
                                                           |
|    |              |              | "10.0.7.93":9779 exec/total/vertices: 153024(us)/164061(us)/1407,                                                          |       "_type",
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:702286(us),HashJoinNode:693062(us),RelNode:702483(us),SingleEdgeNode:690823(us)}         |       "_rank"
                                                           |
|    |              |              | "10.0.7.95":9779 exec/total/vertices: 150819(us)/159393(us)/1331,                                                          |     ],
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 129589(us)/137649(us)/1310,                                                         |     "type": 8
                                                           |
|    |              |              | "10.0.7.92":9779 exec/total/vertices: 148675(us)/158667(us)/1379,                                                          |   },
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 146083(us)/155448(us)/1305,                                                         |   {
                                                           |
|    |              |              | total_rpc_time: 171972(us)                                                                                                 |     "props": [
                                                           |
|    |              |              | "10.0.7.89":9779 exec/total/vertices: 134598(us)/140936(us)/1415,                                                          |       "_dst",
                                                           |
|    |              |              | }                                                                                                                          |       "_type",
                                                           |
|    |              |              | {                                                                                                                          |       "_rank"
                                                           |
|    |              |              | ver: 3, rows: 439300, execTime: 22287us, totalTime: 1313485us                                                              |     ],
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:5813538(us),HashJoinNode:5765338(us),RelNode:5815198(us),SingleEdgeNode:5747447(us)}     |     "type": 6
                                                           |
|    |              |              | "10.0.7.93":9779 exec/total/vertices: 1168882(us)/1223324(us)/11041,                                                       |   },
                                                           |
|    |              |              | "10.0.7.89":9779 exec/total/vertices: 1155649(us)/1196535(us)/10901,                                                       |   {
                                                           |
|    |              |              | "10.0.7.92":9779 exec/total/vertices: 1109186(us)/1153860(us)/10942,                                                       |     "props": [
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 1029007(us)/1075543(us)/11061,                                                      |       "_dst",
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 1201273(us)/1255532(us)/11018,                                                      |       "_type",
                                                           |
|    |              |              | total_rpc_time: 1291176(us)                                                                                                |       "_rank"
                                                           |
|    |              |              | "10.0.7.95":9779 exec/total/vertices: 1154702(us)/1205242(us)/11108,                                                       |     ],
                                                           |
|    |              |              | }                                                                                                                          |     "type": 7
                                                           |
|    |              |              | {                                                                                                                          |   },
                                                           |
|    |              |              | ver: 4, rows: 2169568, execTime: 73265us, totalTime: 4372360us                                                             |   {
                                                           |
|    |              |              | total_rpc_time: 4299066(us)                                                                                                |     "props": [
                                                           |
|    |              |              | "10.0.7.95":9779 exec/total/vertices: 3591425(us)/3797658(us)/35501,                                                       |       "_dst",
                                                           |
|    |              |              | storage_detail: {GetNeighborsNode:15973325(us),HashJoinNode:15790565(us),RelNode:15977855(us),SingleEdgeNode:15736586(us)} |       "_type",
                                                           |
|    |              |              | "10.0.7.93":9779 exec/total/vertices: 3931124(us)/4138709(us)/35359,                                                       |       "_rank"
                                                           |
|    |              |              | "10.0.7.92":9779 exec/total/vertices: 3696592(us)/3909380(us)/35655,                                                       |     ],
                                                           |
|    |              |              | "10.0.7.142":9779 exec/total/vertices: 3287892(us)/3496840(us)/35136,                                                      |     "type": 9
                                                           |
|    |              |              | "10.0.7.89":9779 exec/total/vertices: 3279175(us)/3474221(us)/35300,                                                       |   },
                                                           |
|    |              |              | "10.0.7.100":9779 exec/total/vertices: 3900756(us)/4110543(us)/35366,                                                      |   {
                                                           |
|    |              |              | }                                                                                                                          |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 10
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 12
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": 11
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -8
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -6
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -7
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -9
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -10
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -12
                                                           |
|    |              |              |                                                                                                                            |   },
                                                           |
|    |              |              |                                                                                                                            |   {
                                                           |
|    |              |              |                                                                                                                            |     "props": [
                                                           |
|    |              |              |                                                                                                                            |       "_dst",
                                                           |
|    |              |              |                                                                                                                            |       "_type",
                                                           |
|    |              |              |                                                                                                                            |       "_rank"
                                                           |
|    |              |              |                                                                                                                            |     ],
                                                           |
|    |              |              |                                                                                                                            |     "type": -11
                                                           |
|    |              |              |                                                                                                                            |   }
                                                           |
|    |              |              |                                                                                                                            | ]
                                                           |
|    |              |              |                                                                                                                            | statProps:
                                                           |
|    |              |              |                                                                                                                            | exprs:
                                                           |
|    |              |              |                                                                                                                            | random: false
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
|  0 | Start        |              | ver: 0, rows: 0, execTime: 0us, totalTime: 12us                                                                            | outputVar: {
                                                           |
|    |              |              |                                                                                                                            |   "colNames": [],
                                                           |
|    |              |              |                                                                                                                            |   "type": "DATASET",
                                                           |
|    |              |              |                                                                                                                            |   "name": "__Start_0"
                                                           |
|    |              |              |                                                                                                                            | }
                                                           |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------

Thu, 01 Sep 2022 16:44:09 CST

在nebula-graph.config 中 添加一下 num_operator_threads 这个配置参数,是设置 find path 中并发计算线程的数量的, 可以动态调整一下,找到一个最合适的线程数

2 个赞

问一下,neo4j 测试 最短路径 是用的 allshortestpaths 还是 shortestpath,这两个在neo4j中使用的算法是不一样的

allShortestPaths 用的时这个。
num_operator_threads 这个参数建议调整到多少?我在压测的时候发现,CPU 当前2个thread 都会被拉的很高,这个调高了会不会打爆cpu

【edit: sorry,我刚刚看了下,num_operator_threads=2 default 是2, 不是1, 】

好矛盾啊,不用CPU怎么跑快点呢。。。

话是这么说的,这不得做权衡吗 毕竟集群也有其他业务,如果其他业务不可用了,也是不可接受的 是吧:sleepy:

单独拉一个graphd出来干这个。
存储计算分离的架构,就是给这种混合负载用的嘛

2 个赞

此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。