When trying to use hugepages with mysql, the ulimit of the mysql process must be set at startup. The best way found for this was to edit the initscript and add a ulimit -l line to the top. It would be nice if the ulimit could be set correctly when mysql was configured to use hugepages, but barring that there should be a way to set it for mysql that doesn't require hand-editing the init script.
This request was evaluated by Red Hat Product Management for inclusion, but this component is not scheduled to be updated in the current Red Hat Enterprise Linux release. If you would like this request to be reviewed for the next minor release, ask your support representative to set the next rhel-x.y flag to "?".
One thing we could do about this that doesn't take much thought is to adopt the Fedora packaging guideline recommendation that suggests placing this near the top of the script: [ -e /etc/sysconfig/$prog ] && . /etc/sysconfig/$prog Then you could set what you want in a local sysconfig file. It would be better no doubt to have something smarter, but this beats editing the script directly.
I put the patch suggested in comment #4 into mysql 5.1.44-2. so this is done for Fedora and RHEL-6. Leaving bug open since it's against RHEL-5.
This request was evaluated by Red Hat Product Management for inclusion in the current release of Red Hat Enterprise Linux. Because the affected component is not scheduled to be updated in the current release, Red Hat is unfortunately unable to address this request at this time. Red Hat invites you to ask your support representative to propose this request, if appropriate and relevant, in the next release of Red Hat Enterprise Linux.
This request was erroneously denied for the current release of Red Hat Enterprise Linux. The error has been fixed and this request has been re-proposed for the current release.