Software Architecture

KOVAE is an engine in the MySQL executor layer which is below the optimizer layer. KOVAE uses the plugin API provided by MySQL, and filters and transfers the SQL statements that meet the parallel conditions to the KOVAE execution engine for parallel execution. KOVAE better leverages the multi-core advantage of the Kunpeng server, thereby improving the SQL statement execution performance.

Figure 1 shows the location of KOVAE in MySQL. After the optimizer layer makes an execution plan, KOVAE determines whether the execution plan is to be executed by the MySQL executor or KOVAE itself. In some cases, KOVAE can transfer the execution plan back to the MySQL executor for execution.

Figure 2 shows the KOVAE architecture.

• MySQL plugin API: It is a standard API of the MySQL secondary engine and supports hot installation and hot uninstallation of KOVAE.
• Allowlist control: It ensures that only supported and performance-improved execution plans are executed in KOVAE.
• Execution plan adapter: It transforms MySQL execution plans into execution plans that feature column-store, batch processing, and multi-thread parallel execution.
• Parallel execution operators such as TableScan and Sort: They allow parallel data processing by operators. For details, see Table 1. This improves the multi-core CPU usage and SQL statement execution performance.
• Expressions such as add and minus: They batch process the column-store data, so that the vectorization feature of the Arm server can be used to improve the SQL statement execution performance.