Hi,
if your system suddenly crashs all changes to the database are lost. be aware of this ! regards, philipp p ----- Original Message ----- From: "Shamit Verma" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 11:01 AM Subject: Re: Loading a database into RAM > 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 > > --------------------------------------------------------------------- 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