At 06:58 PM 5/22/2002, you wrote:
>Greetings Friends,
>
>How could cache the whole mysql database in the memory? Which parameters
>would help?
>
>Regards.
>
>Ravi Verma
>916 705 3261
Ravi,
MySQL 4.x already has excellent caching. The best thing you can do
is to add the maximum amount of RAM possible to your machine and let MySQL
caching do the rest. Of course if you need something faster and have a huge
amount of money that is burning a hole in your pocket, you could
*conceivably" put your database on a RAM disk. (I'd recommend trying this
only if it is a read-only database that is replicated or copied from
another source.) There are RAM disk drives with battery backup that will
make database access a lot faster. These devices look like a hard disk and
will retain their contents if the computer crashes or is turned off. They
can also write changes out to a hard disk. If your database is small enough
then you might consider it. I must stress that these battery powered RAM
disks are extremely expensive. An NSD ramdisk costs between $13,000 (2G)
and $50,000 (16G). See http://www.jjcomputer.net/nsdramdisk.htm. I haven't
used it because I don't have a rich uncle.<g>
Mike
---------------------------------------------------------------------
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
