Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Installation Description

  • The feature used for optimization 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 the MySQL Porting Guide.
  1. Create a MySQL user. See Creating a User Group and User" in the MySQL Porting Guide.
  2. Use the MySQL 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 from https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz and save it to the target path, for example, /home.

  3. 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"
    • Generally, Git is provided by the system. If not, configure the Yum repository by following instructions in the 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"
  4. Download the patch file.
    1
    wget https://gitee.com/kunpengcompute/mysql-server/releases/download/KunpengBoostKit21.0.0-threadpool5/0001-THREAD_POOL_5.patch --no-check-certificate
  5. Check whether the content is modified.
    1
    git status
    The following shows that a 0001-THREAD_POOL_5.patch file is added.
    1
2
3
4
5
6
    # 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)
  6. Apply the patch file.
    1
2
    git apply --check 0001-THREAD_POOL_5.patch
git apply --whitespace=nowarn 0001-THREAD_POOL_5.patch
  7. Compile and install the MySQL source code. For details, see the MySQL Porting Guide.
  8. After MySQL is recompiled and installed successfully, 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