Installation Description

The feature used for tuning is provided in a patch. Apply the patch in the MySQL source code, and then compile and install the MySQL database.
The patch is developed for MySQL 5.7.27.
For details about the environment requirements for using the patch, see MySQL Porting Guide.

Create a MySQL user. See Creating a User Group and User in the MySQL Porting Guide.
Use the root account to log in to the server, and download and decompress the MySQL 5.7.27 source package.
1 2 3 4
cd /home wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz --no-check-certificate tar -zxvf mysql-boost-5.7.27.tar.gz cd mysql-5.7.27
You can also download mysql-boost-5.7.27.tar.gz and save it to the target path, for example, /home.
In the root directory of the source code, run the git init command to create Git management information.
1 2 3
git init git add -A git commit -m "Initial commit"
- If an error is reported when you run the git add -A command, run the git config --global --add safe.directory /home/mysql-5.7.27 command as prompted.
- Generally, Git is provided by the system. If not, configure the Yum repository by following instructions in MySQL Porting Guide and then install Git.
  1
  yum install git
- If the Git commit user information is not configured, configure the user email and user name before running the git commit command.
  1 2
  git config user.email "123@example.com" git config user.name "123"

Download the patch file.

wget https://gitee.com/kunpengcompute/mysql-server/releases/download/KunpengBoostKit21.0.0-threadpool5/0001-THREAD_POOL_5.patch --no-check-certificate

Check whether the content is modified.

1	git status

The following shows that a 0001-THREAD_POOL_5.patch file is added.

# On branch master
# Untracked files:
#   (use "git add <file>..." to include in what will be committed)
#
#       0001-THREAD_POOL_5.patch
nothing added to commit but untracked files present (use "git add" to track)

Apply the patch file.

git apply --check 0001-THREAD_POOL_5.patch
git apply --whitespace=nowarn 0001-THREAD_POOL_5.patch

Compile and install the MySQL source code. For details, see MySQL Porting Guide.
After MySQL is compiled and installed successfully, log in to MySQL to check the new information_schema table in the thread pool to ensure that the patch has taken effect. For details, see New information_schema Tables.

Parent topic: MySQL 5.7.27