"undefined symbol: numa_num_configured_cpus" Displayed During MySQL Thread Pool Plugin Installation

Symptom

During the installation of the MySQL thread pool plugin, the message "undefined symbol: numa_num_configured_cpus" is displayed after the INSTALL PLUGIN thread_pool SONAME "thread_pool.so"; statement is executed. The details are as follows:

Can't open shared library'/usr/local/mysql/lib/plugin/thread_pool.so'(errno: 2 /usr/local/mysql/lib/plugin/thread_pool.so:undefined symbol: numa_num_configured_cpus)

Key Process and Cause Analysis

To apply the MySQL thread pool plugin, the numactl library must be installed in the compilation environment. If the numactl library is not installed during compilation, the message "undefined symbol: numa_num_configured_cpus" is displayed when the MySQL program that is not loaded with the NUMA library installs the .so file of the thread pool plugin.

Conclusion and Solution

1. Install the numactl library.

   yum install -y numactl numactl-devel*

2. Recompile MySQL. For details, see MySQL Porting Guide.