echo "192.168.14.141 mysql1" >> /etc/hosts echo "export LANG=en_US" >> ~/.bash_profile 资源限制参数 cat >> /etc/security/limits.conf <<EOF * soft nproc 65535 * hard nproc 65535 * soft nofile 65535 * soft nofile 65535 * soft stack 65535 * soft stack 65535 EOF echo "* - nproc 65535" > /etc/security/limits.d/90-nproc.conf 安全策略 selinux setenforce 0 getenforce echo "SELINUX=disabled" > /etc/selinux/config echo "SELINUXTYPE=targeted" >> /etc/selinux/config cat /etc/selinux/config setenforce 0 关闭防火墙 service iptables stop chkconfig --level 2345 iptables off service firewalld stop Redirecting to /bin/systemctl stop firewalld.service chkconfig --level 2345 firewalld off Note: Forwarding request to 'systemctl disable firewalld.service'. systemctl disable firewalld.service systemctl list-dependencies firewalld echo "session required pam_limits.so" >> /etc/pam.d/login vim /etc/default/grub GRUB_CMDLINE_LINUX="rhgb quiet numa=off" grub2-mkconfig -o /etc/grub2.cfg 重新生成/etc/grub2.cfg grub2-mkconfig -o /etc/grub2-efi.cfg reboot dmesg|grep -i numa dmesg|grep -i numa [ 0.000000] Command line: BOOT_IMAGE=/vmlinuz-3.10.0-1160.81.1.el7.x86_64 root=UUID=839b281c-1683-453e-b28e-ae188dbc4b8e ro rhgb quiet numa=off [ 0.000000] NUMA turned off [ 0.000000] Kernel command line: BOOT_IMAGE=/vmlinuz-3.10.0-1160.81.1.el7.x86_64 root=UUID=839b281c-1683-453e-b28e-ae188dbc4b8e ro rhgb quiet numa=off cat /proc/cmdline BOOT_IMAGE=/vmlinuz-3.10.0-1160.81.1.el7.x86_64 root=UUID=839b281c-1683-453e-b28e-ae188dbc4b8e ro rhgb quiet numa=off numa 参考 https://blog.csdn.net/llh931886/article/details/114361256 io调度算法和io优化操作 cat /sys/block/sd*/queue/scheduler noop [deadline] cfq noop [deadline] cfq noop [deadline] cfq [root@mysql1 ~]# echo 'deadline' > /sys/block/sda/queue/scheduler You have new mail in /var/spool/mail/root [root@mysql1 ~]# cat /sys/block/sd*/queue/scheduler noop [deadline] cfq noop [deadline] cfq noop [deadline] cfq [root@mysql1 ~]# echo 'noop' > /sys/block/sda/queue/scheduler [root@mysql1 ~]# cat /sys/block/sd*/queue/scheduler [noop] deadline cfq noop [deadline] cfq noop [deadline] cfq --sas/stat echo "deadline" > /sys/block/sda/queue/scheduler --ssd echo 'NOOP' > /sys/block/sda/queue/scheduler 减少预读 echo '16' > /sys/block/sda/queue/read_ahead_k echo '16' > /sys/block/sdb/queue/read_ahead_k echo '16' > /sys/block/sdc/queue/read_ahead_k [root@mysql1 ~]# cat /sys/block/sda/queue/nr_requests 128 增大队列 echo '512' > /sys/block/sda/queue/nr_requests echo '512' > /sys/block/sdb/queue/nr_requests echo '512' > /sys/block/sdc/queue/nr_requests vim /etc/rc.local echo '16' > /sys/block/sda/queue/read_ahead_k echo '16' > /sys/block/sdb/queue/read_ahead_k echo '16' > /sys/block/sdc/queue/read_ahead_k echo '512' > /sys/block/sda/queue/nr_requests echo '512' > /sys/block/sdb/queue/nr_requests echo '512' > /sys/block/sdc/queue/nr_requests chmod +x /etc/rc.local vim /etc/sysctl.conf vm.swappiness=10 # 当物理内存剩余10%的时候，使用交换分区 vm.min_free_kbytes=51200 sysctl -p