LinuxHugePages及MySQL大页配置_MySQL

 ⑴ 配置前：[plain] [root@cdio ~]# cat /proc/meminfo | grep -i huge HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 Hugepagesize: 2048 kB ⑵ 设置大页数量、每页通常2M、20个就40M、系统要有足够的内存待分配[plain] [root@obe11g ~]# echo 20 > /proc/sys/vm/nr_hugepages ⑶ 增加最大共享内存段的大小、本例12G[plain] [root@obe11g ~]# echo 1560281088 > /proc/sys/kernel/shmmax ⑷ 增加共享内存的大小、每页4K[plain] [root@obe11g ~]# echo 4194304 > /proc/sys/kernel/shmall ⑸ 将mysql用户所属组添加到系统内核中[plain] [root@obe11g ~]# more /proc/sys/vm/hugetlb_shm_group 0 [root@obe11g ~]# id mysql uid=501(mysql) gid=501(dba) groups=501(dba) [root@obe11g ~]# echo 501 > /proc/sys/vm/hugetlb_shm_group ⑹ 再次确认配置情况[plain] [root@obe11g ~]# cat /proc/meminfo | grep -i huge HugePages_Total: 20 HugePages_Free: 20 Hugepagesize: 4096 kB ⑺ 设置max locked memory[plain] [root@obe11g ~]# cat /etc/security/limits.conf | grep -i mysql mysql hard memlock unlimited mysql soft memlock unlimited ⑻ 配置 my.cnf[plain] [mysqld] large-pages ⑼ 启动mysqld ⑽ 观察HugePages 使用情况[plain] [root@obe11g ~]# grep -i huge /proc/meminfo HugePages_Total: 20 HugePages_Free: 16 Hugepagesize: 4096 kB