Installing and Enabling the Feature

The following uses Percona-Server 5.7.44-53 as an example to describe how to install and enable the computing path optimization feature. The procedure is as follows:

Install the dependencies as instructed in Configuring the Compilation Environment in the Percona Porting Guide.
Download the Percona-Server 5.7.44-53 RPM package described in Table 2 and save the package to the target path, for example, /home.
Run the following commands to install the RPM package. The default installation directory is /usr/local/mysql.
```
cd /home
rpm -ivh BoostDB-Percona-5.7.44-53.aarch64.rpm
```
If dependency packages have been installed but the RPM-related check fails, run the following command to skip the dependency check (using --nodeps):
```
rpm -ivh BoostDB-Percona-5.7.44-53.aarch64.rpm --nodeps
```
For SIMD-based character set processing optimization, add the collation configuration to the MySQL configuration file /etc/my.cnf.
1. Open the /etc/my.cnf file.
```
vi /etc/my.cnf
```
2. Press i to enter the insert mode.
  - If the character set is utf8, add the following configuration to the [mysqld] section:
```
character_set_server = utf8
collation_server = utf8_general_ci
```
  - If the character set is utf8mb4, add the following configuration to the [mysqld] section:
```
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
```
3. Press Esc to exit the insert mode. Type :wq! and press Enter to save the file and exit.
Start the database. For details, see Running MySQL in the MySQL Porting Guide.
For SIMD-based character set processing optimization, query the character set and collation configuration of a database and table. (The following uses the sbtest database and the sbtest1 table in the database as an example.)
```
show create database sbtest;
SHOW VARIABLES LIKE 'collation_database';
show create table sbtest1;
show full columns from sbtest1;
show table status from sbtest like 'sbtest%';
```
For details about how to access the client, see Running MySQL in the MySQL Porting Guide.

Figure 1 Query the character set and collation of the database.

Figure 2 Query the character set and collation of the table.

Figure 3 Obtain the table information of the database. The Collation column indicates the collation.
(Optional) Perform the Sysbench test to compare the performance before and after the computing path optimization feature is enabled. For details about the test procedure, see Sysbench 0.5 & 1.0 Test Guide. The computing path optimization feature improves the Sysbench read-only performance by 10%. Figure 4 shows performance before and after the optimization.
Figure 4 Performance comparison before and after computing path optimization

Parent topic: Feature Guide