Bug #73058 Bootstrap fails on low memory systems without a good error message
Submitted: 20 Jun 2014 7:35
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
Category:MySQL Cluster Manager Severity:S4 (Feature request)
Version:1.3.1 OS:Any
Assigned to: CPU Architecture:Any

[20 Jun 2014 7:35] Daniël van Eeden
On a 64-bit Debian 7.5 system with 1GB RAM:

./mcmd --bootstrap

Expected: running cluster
Actual: failure message, without clear explanation about what failed.

After running the bootstrap with logging to a file and inspecting the file it became clear that the startup of mysqld failed because the InnoDB storage engine failed to register. The InnoDB engine failed to register because it could not allocate memory for the buffer pool (128M).

How to repeat:
Run the bootstrap on a system with 1GB RAM. The Debian system was installed with a minimal installation and was not running anything else (except for OpenSSH server).

Suggested fix:
Solution 1:
Give a warning if a bootstrap is done on a system with less that 2 GB RAM.

Solution 2:
Detect the amount of memory and adjust the InnoDB buffer pool size.

Solution 3:
Show all error messages from the error log if the mysqld startup fails.