前言：本脚本是根据锐志师兄的py脚本改写的shell脚本，貌似平时用起来更方便一些

    1. #! /bin/bash
    2. echo -e "\033[31m ++++++++++MySQL Standardized Check++++++++++++ \033[0m"
    3. echo -e "\n"
    4. echo -e "\033[31m ----------1.File System--------------- \033[0m"
    5. df -Th|awk '{print $1,$2}'|grep -v 'tmpfs'
    6. echo -e "\033[33m 输出建议：数据分区为xfs \033[0m"
    8. echo -e "\n"
    9. echo -e "\033[31m ----------2.IO scheduling algorithm--------------- \033[0m"
    10. cat /sys/block/sda/queue/scheduler
    11. echo -e "\033[33m 输出建议：普通硬盘采用deadline算法，不要用cfg算法;SSD采用noop算法 \033[0m"
    13. echo -e "\n"
    14. echo -e "\033[31m ----------3.max open files--------------- \033[0m"
    15. ulimit -a|grep 'open files'
    16. echo -e "\033[33m 输出建议：建议设置为系统最大65535 \033[0m"
    18. echo -e "\n"
    19. echo -e "\033[31m ----------4.max user processes--------------- \033[0m"
    20. ulimit -a|grep 'processes'
    21. echo -e "\033[33m 输出建议：建议设置为系统最大65535 \033[0m"
    23. echo -e "\n"
    24. echo -e "\033[31m ----------5.numa enable--------------- \033[0m"
    25. grep -i numa /var/log/dmesg
    26. echo -e "\033[33m 输出建议：强烈建议关闭NUMA \033[0m"
    28. echo -e "\n"
    29. echo -e "\033[31m ----------6.swappiness ratio--------------- \033[0m"
    30. sysctl -a | grep swappiness
    31. echo -e "\033[33m 输出建议：建议值设置为1-10 \033[0m"
    33. echo -e "\n"
    34. echo -e "\033[31m ----------7.dirty_ratio--------------- \033[0m"
    35. sysctl -a | grep dirty_ratio
    36. echo -e "\033[33m 设置为10比较好 \033[0m"
    38. echo -e "\n"
    39. echo -e "\033[31m ----------8.dirty_background_ratio--------------- \033[0m"
    40. sysctl -a | grep dirty_background_ratio
    41. echo -e "\033[33m 输出建议：设置为5比较好 \033[0m"
    43. function IO_scheduler()
    44. {
    45.   echo -e "\n" 
    46.   read -t 10 -p "IO scheduling optimization[Y/N]:" need
    47.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    48.   if [ "$need_U" = 'Y' ]; then
    49.     echo "deadline" > /sys/block/sda/queue/scheduler
    50.     if [ $? = 0 ];then
    51.       echo -e "\033[33m IO scheduling changed \033[0m"
    52.     else
    53.       echo -e "\033[33m error please check manually \033[0m"
    54.     fi
    55.   fi
    56. }
    58. function open_file()
    59. {
    60.   echo -e "\n" 
    61.   read -t 10 -p "change max open files[Y/N]:" need
    62.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    63.   if [ "$need_U" = 'Y' ]; then
    64.     echo '* soft nofile 65536' >>/etc/security/limits.conf
    65.     if [ $? = 0 ];then
    66.       echo -e "\033[33m soft file changed \033[0m"
    67.     else
    68.       echo -e "\033[33m error please check manually \033[0m"
    69.     fi
    70.     echo '* hard nofile 65536' >>/etc/security/limits.conf
    71.     if [ $? = 0 ];then
    72.       echo -e "\033[33m hard file changed \033[0m"
    73.     else
    74.       echo -e "\033[33m error please check manually \033[0m"
    75.     fi
    76.     ulimit -HSn 65535
    77.     if [ $? = 0 ];then
    78.       echo -e "\033[33m open files changed online \033[0m"
    79.     else
    80.       echo -e "\033[33m error please check manually \033[0m"
    81.     fi
    83.   fi
    84. }
    86. function user_process()
    87. {
    88.   read -t 10 -p "change max user processes[Y/N]:" need
    89.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    90.   if [ "$need_U" = 'Y' ]; then
    91.     echo '* soft nproc 65536' >>/etc/security/limits.conf
    92.     if [ $? = 0 ];then
    93.       echo -e "\033[33m max user processes changed \033[0m"
    94.     else
    95.       echo -e "\033[33m error please check manually \033[0m"
    96.     fi
    97.     ulimit -HSu 65535
    98.     if [ $? = 0 ];then
    99.       echo -e "\033[33m max user processess changed online \033[0m"
    100.     else
    101.       echo -e "\033[33m error please check manually \033[0m"
    102.     fi
    103.   fi
    104. }
    106. function disable_numa()
    107. {
    108.   echo -e "\n" 
    109.   read -t 10 -p "disabled NUMA[Y/N]:" need
    110.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    111.   if [ "$need_U" = 'Y' ]; then
    112.     yum install numactl -y
    113.     if [ $? = 0 ];then
    114.       echo -e "\033[33m numactl is installed successfully \033[0m"
    115.     else
    116.       echo -e "\033[33m error please check manually \033[0m"
    117.     fi
    118.     echo -e "\033[33m please use numactl --interleave=all mysqld to start MySQL \033[0m"
    119.   fi
    120. }
    122. function swappiness_ratio()
    123. {
    124.   read -t 10 -p "change swappiness_ratio[Y/N]:" need
    125.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    126.   if [ "$need_U" = 'Y' ]; then
    127.     echo 'vm.swappiness = 10'>>/etc/sysctl.conf
    128.     if [ $? = 0 ];then
    129.       echo -e "\033[33m swappiness_ratio changed \033[0m"
    130.     else
    131.       echo -e "\033[33m error please check manually \033[0m"
    132.     fi
    133.   fi
    134. }
    138. function dirty_ratio()
    139. {
    140.   echo -e "\n" 
    141.   read -t 10 -p "change dirty_ratio[Y/N]:" need
    142.   need_U=$(echo $need | tr '[a-z]' '[A-Z]')
    143.   if [ "$need_U" = 'Y' ]; then
    144.     echo 'vm.dirty_background_ratio = 5' >>/etc/sysctl.conf
    145.     if [ $? = 0 ];then
    146.       echo -e "\033[33m dirty_background_ratio changed \033[0m"
    147.     else
    148.       echo -e "\033[33m error please check manually \033[0m"
    149.     fi
    150.     echo 'vm.dirty_ratio = 10' >>/etc/sysctl.conf
    151.     if [ $? = 0 ];then
    152.       echo -e "\033[33m dirty_ratio changed \033[0m"
    153.     else
    154.       echo -e "\033[33m error please check manually \033[0m"
    155.     fi
    156.     /sbin/sysctl -p
    157.     if [ $? = 0 ];then
    158.       echo -e "\033[33m changes successfully \033[0m"
    159.     else
    160.       echo -e "\033[33m error please check manually \033[0m"
    161.     fi
    162.   fi
    163. }
    165. IO_scheduler
    166. open_file
    167. user_process
    168. disable_numa
    169. swappiness_ratio
    170. dirty_ratio
    171. echo -e "\n"
    172. echo -e "\033[33m restart system and check again！ \033[0m"