[Voyage-linux] LEDs, APT repository, MySQL in RAM questions

[Michael Fung]

On 2010/6/26 上午 12:47, Andreas Delleske wrote:
> 4. MySQL database in RAM
> 
> I'll use the ALIX board with mysql / lighttpd and php5, which works
> fine. I followed this guide:
> 
> http://www.howtoforge.com/installing-lighttpd-with-php5-and-mysql-support-on-debian-lenny
> 
> Now I am unsure whether I should move the /var/lib/mysql folder to the
> rw / ro mechanism so writing to the DB does not spoil the flash so
> fast. Does anyone have experiences on wearout when using a 4 GByte
> flash for about 500 MByte? My database is about 50 MB and will reach
> 100 MB. If I reserve 100 of 256 MByte for MySQL, maybe the RAM is not
> enough for the functioning of the rest of applications?
> 

For that size I suggest adding a 2.5" usb HDD to hold the database
files. However, if you must run the data in RAM, this article may help:

http://www.3open.org/d/voyage/run_mysql_with_data_files_in_memory

Rgds,
Michael