mysql 5.6 numa 禁用参考

核心还是安装 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/