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? I am thinking about creating a heap
table,
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 database
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: Loading a database into RAM
You may
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? I
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