Hi Guys, I wouldn't automatically disregarded MySQL as being not possible to utilize on a single board controller; what about a tunnel or parodying solution; such as `mysql-proxy`?
It's memory usage would I assume be lower? On Sep 1, 2013, at 1:34 PM, Gary Mort <garyam...@gmail.com> wrote: > As a followup on my previous post, I'm curious if anyone here has some quick > and easy mysql configuration mods for low memory? > > The "out of the box" ubuntu install of mysql server used a hefty[:-)] 256M of > memory. As a quick fix I disabled innodb completely and that dropped it > down to more manageable 64M - but I'd really like to get it down to under 24M. > > For the use case[running on a System on a Chip board] myisam is a better > choice anyway - large numbers of concurrent connections are unlikely, and the > need for row-level locking is practically non-existent. > > For those that aren't familiar with the environment, the entire system has > 512M of memory so using half of it for a sporadically utilized MySQL server > is detrimental. There is no traditional hard disk available, disk storage > is provided by an SD card, which does not have very fast write times AND > deleting and writing data is destructive to the long term lifespan of the > card - just like with SSD drives. Swapfiles do a lot of > write/delete/write/delete to pull memory in and out of swap, so their use is > discouraged. > > > _______________________________________________ > New York PHP User Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/show-participation _______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show-participation