Hi.
If you are using a decent operating system and have enough memory, it
will do it for you implicitly by caching the files. This is not as
fast as it could be (because the content still has to be evaluated
each time), but already gives you the main speed advantage of memory
vs. disks.
If you want finer control, have a look at SHOW VARIABLES and SHOW
STATUS in the manual.
You could also create the tables as TYPE HEAP, but that brings a lot
of caveats with it, and therefore it's usually not worth to bother,
except you really know you need this.
Regards,
Benjamin.
On Wed, May 22, 2002 at 04:58:14PM -0700, [EMAIL PROTECTED] wrote:
> Greetings Friends,
>
> How could cache the whole mysql database in the memory? Which parameters
> would help?
>
> Regards.
>
> Ravi Verma
> 916 705 3261
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
