Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
For bugs related to Red Hat Enterprise Linux 5 product line. The current stable release is 5.10. For Red Hat Enterprise Linux 6 and above, please visit Red Hat JIRA https://issues.redhat.com/secure/CreateIssue!default.jspa?pid=12332745 to report new issues.

Bug 565534

Summary: Get ulimit right when trying to use hugepages
Product: Red Hat Enterprise Linux 5 Reporter: Casey Dahlin <cdahlin>
Component: mysqlAssignee: Tom Lane <tgl>
Status: CLOSED NEXTRELEASE QA Contact: qe-baseos-daemons
Severity: medium Docs Contact:
Priority: low    
Version: 5.4CC: byte, hhorak, iannis, vanhoof, wnefal+redhatbugzilla
Target Milestone: rc   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-10-17 05:40:21 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Casey Dahlin 2010-02-15 15:36:56 UTC
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.

Comment 1 RHEL Program Management 2010-02-15 15:47:55 UTC
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 "?".

Comment 4 Tom Lane 2010-02-22 02:07:31 UTC
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.

Comment 5 Tom Lane 2010-05-24 15:47:22 UTC
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.

Comment 7 RHEL Program Management 2010-08-09 18:14:13 UTC
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.

Comment 8 RHEL Program Management 2011-01-11 20:05:16 UTC
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.

Comment 9 RHEL Program Management 2011-01-11 23:06:59 UTC
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.

Comment 10 RHEL Program Management 2011-05-31 13:14:42 UTC
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.