"failed to match build-id from perf output" Displayed During Automatic FDO

Symptom

The message "failed to match build-id from perf output" is displayed during automatic FDO.

Key Process and Cause Analysis

The USE_LD_LLD option of MySQL is enabled, which conflicts with A-FOT.

Conclusion and Solution

1. Modify the CMakeLists.txt file in the MySQL source code directory. If the source code directory is /root/mysql-8.0.25/, the file path is /root/mysql-8.0.25/CMakeLists.txt.

   Change the value of the USE_LD_LLD option from ON to OFF, as shown in the following figure:

   

2. Perform automatic FDO again.