>From my experience: don't do anything.
Linux filesystem cache is really efficient and as soon as all your database
will be in the cache, you wont get any disk read anymore; only writes when
you INSERT/UPDATE data.
Our main database server has 2Gb RAM and the total size of all databases
is around
Steve Quezadas <[EMAIL PROTECTED]> writes:
> 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
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: Loadi
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 da
