MySQL (mariadb) Installation Issues - Raspberry Pi Forums

hello forum,

have attempted install mysql on old 256mb raspberry pi. have done following steps.

code: select all

pacman -syu mariadb libmariadbclient mariadb-clients cp /usr/share/mysql/my-small.cnf /etc/mysql/my.cnf systemctl start mysqld 

however, daemon fails start :

code: select all

* mysqld.service - mariadb database server    loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)    active: activating (start-post) (result: exit-code) since sat 2015-04-18 21:47:49 bst; 1min 7s ago   process: 11249 execstart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/failure)  main pid: 11249 (code=exited, status=1/failure);         : 11250 (mysqld-post)    cgroup: /system.slice/mysqld.service            `-control              |-11250 /bin/sh /usr/bin/mysqld-post              `-11708 sleep 1  apr 18 21:47:49 raspberry03 mysqld[11249]: innodb: mmap(135987200 bytes) failed; errno 12 apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] innodb: cannot allocate memory buffer pool apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] plugin 'innodb' init function returned error. apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] plugin 'innodb' registration storage engine failed. apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [note] plugin 'feedback' disabled. apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] can't open mysql.plugin table. please run mys...te it. apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] unknown/unsupported storage engine: innodb apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [error] aborting apr 18 21:47:49 raspberry03 mysqld[11249]: 150418 21:47:49 [note] /usr/bin/mysqld: shutdown complete apr 18 21:47:50 raspberry03 systemd[1]: mysqld.service: main process exited, code=exited, status=1/failure

issue gratefully received...

harold clements

remember default settings in /etc/mysql/my.cnf (or wherever goes on arch) going assume machine has 4gb of ram , mysql (& mariadb) likes use memory.

need drastically reduce sizes of buffers , memory allocations run on small rpi.

rid of innodb, convert aria , can disable engine.

raspberrypi