MySQL Forums
Forum List  »  Performance

Re: large-pages variable set but mysql doesn't use huge pages
Posted by: Arnold Maderthaner
Date: April 23, 2008 11:15PM

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 !

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.