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



Comments

Post a Comment

Popular posts from this blog

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

-
dear all, working on image processing using raspberry pi, have installed intex usb web camera on raspberry pi. have used basic python script of image processing https://www.cl.cam.ac.uk/projects/raspb ... first.html required libraries installed on raspberry pi. script code: import imgproc imgproc import * # open webcam take pictures camera = camera(160, 120) # open viewer window display images viewer = viewer(160, 120, "the first step") # take picture camera img = camera.grabimage() # display image in viewer viewer.displayimage(img) # iterate on each pixel in image x in range(0, img.width): for y in range(0, img.height): # value @ xth column , yth row, place intensities variables red, green, blue = img[x, y] # test find colour dominant if red > green , red > blue: # red dominant, set pixel red img[x, y] = 255, 0, 0 elif green > red , green > blue: img[x, y] = 0, 255, 0 else: # if red or gr...
Read more

using a laptop skeleton to build a pi laptop - Raspberry Pi Forums

-
Image
i have laptop dead motherboard . can remove components laptop , in anyway possible connect raspberry pi inbuilt display , keyboard on laptop ? (and touchpad if possible). (i figured remove components inside , fix pie inside , use extended usb cable , connect available usb ports respective holes in laptop skeleton, same headphone out ) . i'm noob when comes pi . on topic appreciated if screen lvds type may possible use screen installing converter board. this: http://www.ebay.com/itm/hdmi-dvi-vga-dr ... 3027&rt=nc need model number of screen , ask seller if work. or search ebay using brand , model number. assuming screen in working order..... back-light not burnt out etc.. other devices...... can used if have usb interface not part of motherboard. have make connector. raspberrypi
Read more

Smoothing Capacitor value?

-
Image
hi everyone! i have question "smoothing capacitors". have 5v arduino project have 6 individual 5v components attached it. since need these running @ different times, wanted take similar approach of nick gammon's in helpful example (http://www.gammon.com.au/forum/?id=12106) , use few mosfets switch these little guys on & off individually (instead of regular arduino pins), while minimizing potential power surges affect microcontroller and/or components themselves. these components 5v, , have maximum draw of ~170ma when powered on @ same time. so, if used 6 different mosfet switches turn switch +5v power line on each component directed via arduino uno, wondering: 1. still use 1 capacitor (like nick did in example)? 2. capacitor of 100uf work, or should use bigger? my plan first test circuit mosfets & capacitor(s) using usb, , later on, moving project battery power. thanks in advance ideas & suggestions! quote these little guys what ...
Read more