ApsaraDB for OceanBase:Parameter templates

Background information

ApsaraDB for OceanBase allows you to select different parameter templates when creating a tenant based on your business requirements to ensure optimal performance.

ApsaraDB for OceanBase supports the following parameter templates:

• Simple OLTP (default): suitable for core systems for Internet businesses that require point queries with high concurrency, such as online order transactions and payments. The SQL statements executed are simple, ensuring a fast response speed.

• Complex OLTP: suitable for online transaction systems with complex transactions. This includes handling long-running and large transactions that involve complex joins, subqueries, and batch jobs written in PL. If a cluster instance is dedicated for online transactional processing (OLTP) workloads, we recommend that you optimize the value of the large_query_threshold parameter from the default 600 seconds to 5 seconds.

• HTAP: suitable for systems that simultaneously run OLTP and online analytical processing (OLAP) workloads for improved performance in online analysis though a vectorized engine.

• OLAP: suitable for real-time data warehouses that require OLAP. By default, tables created use columnar storage and an optimized vectorized engine to enhance performance for complex analysis. If a cluster instance is dedicated for OLAP workloads, we recommend that you optimize system variables and cluster parameters. This includes enabling adaptive parallel computation, optimizing SQL statement sorting memory, configuring timeout settings for SQL statements and transactions, and adjusting large query strategies. We also recommend that you use the character set 10utf8mb4_bin for tenants.

Comparison