Others
In this topic, I will share with you some information related to analytical processing (AP) scenarios.
Recommended Configurations in AP Scenarios
-
Simply put, we recommend that you directly use a parameter template. Parameter templates can free you from manual parameter configuration. For more information, see Parameter Templates in this advanced tutorial.
-
The detailed parameter configurations in each template are also available for your reference:
Best Practices for Parallel Execution
-
Recommended blog: Mastering Parallel Execution in OceanBase Database
- The content in this blog is a little bit demanding and is applicable to users who want to know about AP. Before you read this blog, we recommend that you first learn how to read and manage execution plans.
-
Recommended blog: Auto DOP in OceanBase Database V4.2
- With the auto degree of parallelism (DOP) feature, you do not need to manually set a DOP.
- If you do not have time to read all the recommended blogs, you must know how to set an optimal DOP by simply performing the following two steps:
- Set the maximum DOP based on the server performance and the acceptable resource usage by complex queries, for example,
set parallel_degree_limit = 32;. - Specify
set parallel_degree_policy = AUTO;to enable auto DOP.
- Set the maximum DOP based on the server performance and the acceptable resource usage by complex queries, for example,
Best Practices for Columnar Storage
-
Recommended blog: Columnstore Engine: Your Ticket to OLAP
- The columnar storage feature of OceanBase Database is being improved. Best practices for new capabilities such as columnstore replicas will be added here later.