I've tested on Amazon Linux 2 and Amazon Linux 2023 for cpu performance.
The testing CPU is AWS EC2 m5zn.6xlarge with 24 vCPUs (Intel(R) Xeon(R) Platinum 8252C CPU @ 3.80GHz with HT on).
Amazon Linux 2: GCC7, GLIBC 2.26, MariaDB-devel 5.5, OpenSSL-devel 1.0.2
Kernel version 4.14 and 5.10
Amazon Linux 2023: GCC1, GLIBC 2.34, MariaDB-devel 10.11, OpenSSL-devel 3.2.2
Kernel version 6.1 and 6.12
My testing command is:
sysbench --threads=24 --time=600 cpu run
The number is events/second.
These shows different performance on compile with MySQL module or without MySQL module on Amazon Linux 2023.
Why will the cpu performance be affected because of the mysql module compilation configuration?