核心还是安装 numactl 我们基于numactl 进行参数调整
需要修改的启动配置
numactl --interleave=all /usr/bin/mysqld_safe --basedir=/usr
systemd 参考
[Unit]
Description=MySQL Community Server
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
Alias=mysql.service
[Service]
User=mysql
Group=mysql
# Execute pre and post scripts as root
PermissionsStartOnly=true
# Needed to create system tables etc.
ExecStartPre=/usr/bin/mysql-systemd-start pre
# Start main service
ExecStart=/usr/bin/numactl --interleave=all /usr/bin/mysqld_safe --basedir=/usr
# Don't signal startup success before a ping works
ExecStartPost=/usr/bin/mysql-systemd-start post
# Give up if ping don't get an answer
TimeoutSec=600
Restart=always
PrivateTmp=false
LimitNOFILE=65535
LimitNPROC=65535
参考资料
https://man7.org/linux/man-pages/man8/numactl.8.html
http://mysql.taobao.org/monthly/2015/07/06/