Partition splitting is the process of dividing a partition into two or more new partitions based on specified rules. This process is typically applied to large tables in a database to prevent excessive data accumulation in a single partition, thereby improving data management and query performance.
Types of partition splitting
OceanBase AI Database in MySQL-compatible mode supports the following types of partition splitting:
- Manual partition splitting
- Automatic partition splitting
Manual partition splitting
Manual partition splitting involves splitting partitions in an existing partitioned table. OceanBase AI Database supports manual execution of partition splitting commands using MySQL-compatible syntax, enabling you to divide an existing partition into multiple partitions.
For more information, see Manually split a partition.
Automatic partition splitting
Automatic partition splitting is a partitioning operation performed by the system based on predefined automatic partitioning rules (including the SIZE clause and automatic partitioning parameters). In OceanBase AI Database, you can set automatic partitioning rules in advance. When the data grows to a certain extent, the system automatically splits the partition, enabling the database table to scale out automatically as data volumes increase. This prevents performance issues and load imbalances caused by oversized partitions.
For more information, see Automatic partition splitting.