mySQL in-memory configuration
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 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
Re: mySQL in-memory configuration
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, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: mySQL in-memory configuration
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 memory and are never written to disk? TIA, Tim Banach - 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 mysql-unsubscribe- [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
Re: mySQL in-memory configuration
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 possible to start your 'embedded' server using the 'skip-defaults' option (this should remove *some* of the reliance on the 'on-disk' data. I guess what we really want to do is create heap-db's rather than just heap-tables, (then create the actual user/grant tables in there). It would be nice to be able to:- Create heap-table load grants tables from state/startup file etc. If anyone knows how to create a 'true' embedded server, and can connect a client to it, please let us know. Mark -- Acronym of the day: MICROSOFT (Most Intelligent Customers Realize Our Software Only Fools Twits) - 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