Re: large-pages variable set but mysql doesn't use huge pages

[Arnold Maderthaner]

this is my setup I did for mysql:
/etc/sysctl.conf:

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736 <-- redhat default

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296 <-- redhat default
vm.hugetlb_shm_group = 502
vm.nr_hugepages = 1010

/etc/security/limits.conf:
myuser soft memlock 2068480
myuser hard memlock 2068480
root soft memlock 2068480
root hard memlock 2068480
mysql soft memlock 2068480
mysql hard memlock 2068480

As this works for my jboss which runs under the user "myuser".
So I don't know what I should set for mysql !