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 _______________________________________________ Voyage-linux mailing list [email protected] http://list.voyage.hk/mailman/listinfo/voyage-linux
