mySQL in-memory configuration

2001-12-03 Thread Banach, Timothy P
Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident in memory and are never written to disk? TIA, Tim Banach - Before posting, please

Re: mySQL in-memory configuration

2001-12-03 Thread Sinisa Milivojevic
Banach, Timothy P writes: Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident in memory and are never written to disk? TIA, Tim Banach Hi! Take a look at our HEAP table type. -- Regards, __

Re: mySQL in-memory configuration

2001-12-03 Thread Erik Price
I'm not sure, but you'd be in big trouble if your system lost power! -- Erik On Monday, December 3, 2001, at 10:50 AM, Banach, Timothy P wrote: Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident in

Re: mySQL in-memory configuration

2001-12-03 Thread Mark Greatrix
Tim, I *really* want to do the same thing, and I'm currently playing with the embedded server to see if that will help me. Unfortunately even the embedded example doesn't really help much as it relies on having another 'mysqld' server process running to connect to (AFAICT). It should be