Performing Automatic FDO

This section describes how to perform automatic FDO. In this process, FDO sampling, analysis, and optimization are automatically completed to improve system performance.

1. Run the following command to go to the A-FOT directory and perform automatic FDO:

   1	cd A-FOT && ./a-fot

   If success is displayed, the compilation is successful.

   

   

   In the command output, /tmp/20221126-084849/opt.log is the log file of automatic FDO, which can be used to check the feature enabling progress and locate faults.

2. Search for and display all section information that contains the bolt string.

   1	readelf -a /usr/local/mysql-gcc/bin/mysqld | grep bolt

   If the following information is displayed, the automatic FDO feature is enabled:

   

3. Optional: Perform TPC-C tests to obtain performance data before and after the GCC CFGO feature is used. For details about the tests, see BenchMarkSQL Test Guide.
   The GCC CFGO feature improves the comprehensive TPC-C performance by 10%. Figure 1 shows the performance before and after the optimization.

   Figure 1 Performance comparison