Updated on 2022-11-18 GMT+08:00

Adjusting Execution Plan Cache

Scenario

HetuEngine provides the execution plan cache function. For the same query that needs to be executed for multiple times, this function reduces the time required for generating the execution plans for the same query.

Procedure

  1. Log in to FusionInsight Manager.
  2. Choose Cluster > Services > HetuEngine > Configurations > All Configurations and adjust the execution plan cache parameters by referring to Table 1.

    Table 1 Execution plan cache parameters

    Parameter

    Default Value

    Recommended Value

    Description

    Parameter File

    hetu.executionplan.cache.enabled

    false

    true

    Indicates whether to enable the global execution plan cache.

    coordinator.config.properties and worker.config.properties

    hetu.executionplan.cache.limit

    20000

    Adjust the value based on application requirements.

    Indicates the maximum number of execution plans that can be cached.

    coordinator.config.properties and worker.config.properties

    hetu.executionplan.cache.timeout

    86400000

    Adjust the value based on application requirements.

    Indicates the timeout interval of the cached execution plan since the last access, in milliseconds.

    coordinator.config.properties and worker.config.properties

  3. Click Save.
  4. Choose Cluster > Services > HetuEngine > More > Restart Service to restart the HetuEngine service for the parameters to take effect.