Overview

This document describes how to install and enable the computing path optimization feature on a Kunpeng server.

In MySQL online transaction processing (OLTP) scenarios, when the Sysbench tool is used to perform read-only tests, performance monitoring reveals that the main hotspot functions include record matching-related functions (such as row_search_mvcc, rec_get_offsets_func, page_cur_search_with_match, and btr_cur_search_to_nth_level) and character set processing-related functions (such as my_strnxfrm_unicode, my_ismbchar_utf8, my_charpos_mb, my_hash_sort_utf8, and my_lengthsp_8bit). Kunpeng BoostKit has made multiple optimizations on these hotspot functions, significantly improving the execution efficiency.

In addition, the new Kunpeng 920 processor model supports unaligned memory access. Therefore, the unaligned memory access optimization policies implemented on the x86 architecture can be smoothly migrated to the Arm architecture. This further improves the overall system performance.

With the preceding optimizations, Sysbench read-only tests show that the performance of Percona-Server 5.7.44-53 running on a container with 8 vCPU and 16 GB memory can be improved by about 10%.