Parameter template overview

This topic describes the key parameters and differences between parameter templates when creating tenants.

Background

OceanBase Cloud supports selecting different parameter templates when creating tenants to quickly match specific usage scenarios. Users can choose appropriate parameter templates for different business scenarios to achieve optimal performance.

Currently supported parameter templates include:

• OLTP Simple Transactions (Default): Suitable for core systems such as online orders and payments, as well as high-concurrency, point-query-intensive internet applications. Ideal for scenarios with simple SQL executions requiring fast responses.

• OLTP Complex Transactions: Suitable for online transaction systems with complex transactions, such as scenarios involving complex join calculations, subqueries, or batch jobs written in PL. Supports long or large transactions. If the instance is dedicated to OLTP workloads, it is recommended to optimize the instance parameter large_query_threshold from the default 600s to 5s.

• HTAP Mixed Workloads: Suitable for hybrid workloads running both transactions and online analysis. Enhances computing capabilities for analytical scenarios through vectorization while maintaining OLTP performance.

• OLAP Online Analytics: Suitable for real-time data warehouse scenarios with online analytical processing (OLAP). Tables are created using columnar storage by default, with an optimized vectorization engine to enhance computing capabilities for complex analytical scenarios. For instances dedicated to OLAP analytics, it is recommended to optimize system variables and instance parameters accordingly, such as enabling adaptive parallel computing, optimizing SQL sorting memory space, configuring SQL and transaction timeouts, and large query policies. It is also recommended to use utf8mb4_bin as the tenant character set.

Parameter template comparison