[SOLVED] Error Installing MariaDB on Model B Rev.1

[ajhlinuxuser]

Hello,

I wanted to post the solution to an error I encountered while installing MariaDB on a revision 1 board. This is the one with 256MB of RAM, so I don't know if it occurs on the revision 2 (512MB RAM) units.

$this->bbcode_second_pass_code('', '[ERROR] mysqld: Out of memory (Needed 130760704 bytes)')

My solution:

Create a swapfile that is 256MB in size (if you have this error, you probably are too late to make a swap partition).
$this->bbcode_second_pass_code('', '# dd if=/dev/zero of=/swapfile bs=1M count=256
# mkswap /swapfile
# swapon /swapfile
')

And then retry starting mysqld. Should work without errors.

[moonman]

swap on an sd card is a bad idea. A possible solution if you are running headless is to decrease GPU assigned memory to a minimum of 48MB and disable dynamic memory split in config.txt Also there were several threads on optimizing MariaDB memory usage in armv5 forums.