Mark Papadakis wrote:
> It might sound a bit crazy, but is there any way I can get Linux/mySQL to cache
> a database. Even if it 'd take 500Megs to do that, we are willing to go for it
> to get the speed we need for our search engine project.
> I don't think it can be done, just thought I 'd ask. Btw, if anyone is
> interested in linux, check http://linux.pathfinder.gr/
> Thank you,
One sure way to do it is create a RAM disk, and every time you boot,
mount it on /usr/local/mysql/data/my_fast_database then copy
to my_fast_database, and periodically runcheckpoints to make sure you do
not loose you updates if the system crashes.