数据库redhat6.2以上都需要关闭透明大页
===========================redhat6.*修改文件位置=========================
1、修改启动文件
vi /etc/grub.conf
# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You have a /boot partition. This means that
# all kernel and initrd paths are relative to /boot/, eg.
# root (hd0,0)
# kernel /vmlinuz-version ro root=/dev/sda6
# initrd /initrd-[generic-]version.img
#boot=/dev/sda
default=0
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title Red Hat Enterprise Linux 6 (2.6.32-504.el6.x86_64)
root (hd0,0)
kernel /tboot.gz logging=vga,serial,memory
module /vmlinuz-2.6.32-504.el6.x86_64 ro root=UUID=24a981d1-6848-4af9-969a-93bd1519f81e intel_iommu=on amd_iommu=on rd_NO_LUKS rd_NO_LVM LANG=en_US.UTF-8 rd_NO_MD SYSFONT=latarcyrheb-sun16 crashkernel=128M KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM rhgb quiet transparent_hugepage=never
module /initramfs-2.6.32-504.el6.x86_64.img
系统重启前查看参数
[root@rac1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
[root@rac1 ~]# cat /sys/kernel/mm/transparent_hugepage/defrag
[always] madvise never
重启后查看参数生效
[root@bak ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
=======================redhat7.*修改文件位置======================
1、备份文件cp /etc/default/grub /etc/default/grub.bak
2、修改vi /etc/default/grub
GRUB_CMDLINE_LINUX="rhgb quiet transparent_hugepage=never"
3、On BIOS-based machines: ~]# grub2-mkconfig -o /boot/grub2/grub.cfg
On UEFI-based machines: ~]# grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg
4、重启reboot
5、查看参数生效
[root@localhost yucanlin]# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
[root@localhost yucanlin]# cat /sys/kernel/mm/transparent_hugepage/defrag
always madvise [never]
[yucanlin@localhost ~]$ grep Huge /proc/meminfo
AnonHugePages: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB