Rate This Document
Findability
Accuracy
Completeness
Readability

Enabling Gazelle in MySQL

  1. Start the MySQL server.
    1
    LD_PRELOAD=/usr/lib64/liblstack.so GAZELLE_BIND_PROCNAME=mysqld /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --bind-address=192.168.200.8 &
    

    Modify the following parameters as required:

    • /usr/local/mysql/bin/mysqld: MySQL installation path
    • /etc/my.cnf: path to the MySQL configuration file
    • 192.168.200.8: allocated service IP address

    MySQL is started successfully if information similar to the following is displayed:

  2. Verify that Gazelle has been successfully configured. If the service network is connected, Gazelle is enabled successfully. Run the following command on the client server to log in to the MySQL client and check whether the service network is normal:
    1
    /home/mysql-8.0.25/build_release/install/bin/mysql -uroot -p123456 -h192.168.200.8 -P3316
    

    Modify the following parameters as required:

    • /home/mysql-8.0.25/build_release/install/bin/mysql: MySQL client installation path
    • 192.168.200.8: allocated service IP address
    • 3316: allocated service port number

    If information similar to the following is displayed, the service network connectivity is normal.

  3. Perform a TPC-C test to obtain the performance improvement data after the Gazelle network optimization feature is used. For details about the test, see BenchmarkSQL Test Guide.
    The Gazelle network optimization feature improves the comprehensive TPC-C performance by 10%. Figure 1 shows the effect before and after the optimization.
    Figure 1 Performance comparison before and after Gazelle network optimization is used