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

Reply via email to