Bug #24461 LockPagesInMainMemory
Submitted: 21 Nov 2006 10:10 Modified: 28 Dec 2006 13:51
Reporter: Mikael Ronström Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1, 5.0 and 5.1 (found in 5.1) OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[21 Nov 2006 10:10] Mikael Ronström
Description:
The configuration parameter LockPagesInMainMemory
is a no-op due to placement of it in code which is never executed.
It's easy to fix.

How to repeat:
Set parameter and note with top that memory is still left in swap.

Suggested fix:
Move it from dead code else-part to live else-part.
[22 Nov 2006 13:09] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/15700

ChangeSet@1.2559, 2006-11-22 14:05:40+01:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#24461 - LockPagesInMemory ignored
    actually do run mlockall
[22 Nov 2006 13:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/15703

ChangeSet@1.2560, 2006-11-22 14:13:32+01:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#24461
  m  ove mlock to much earlier in startphases
    not to affect heartbeats
[18 Dec 2006 13:25] Lars Torstensson
Is it possible to apply this patch on 5.0 ?
[28 Dec 2006 11:58] Tomas Ulin
fixed in 5.0.31 and 5.1.14
[28 Dec 2006 13:51] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented fix in 5.0.32 & 5.1.14 changelogs.
[4 Jan 2007 11:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17618
[15 Apr 2007 17:02] Bugs System
Pushed into 4.1.23