You may try using a Ramdisk as storage for mysql "data" folder. Regards, Shamit http://www.vshamit.com
----- Original Message ----- From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 2:53 PM Subject: Loading a database into RAM > 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 > > --------------------------------------------------------------------- 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