Loading a database into RAM

[Steve Quezadas]

I have a mySQL database that is about 240 megabytes. I am loading it on a Linux server with 2 gigs of RAM. I would like to have the whole table reside in memory to save time from disk access. Is there any way to load the tables into RAM on startup? I am thinking about creating a heap table, but I need the heap table to be lodaed when mysql gets loaded. Is there anyway to do this? Or perhaps it is best to put the table in a RAM disk or something?

Anyone know a generally recommended solution?

-Steve


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php