I currently have my database on a ramfs (supported by kernel 2.4.0) on a production
environment.
I have also used ramdisks, although they seem to have a 512Mb limit, even though you
can make more than one (before using ramfs I had 2 ramdisks).
Bye,
Enea
-----Messaggio originale-----
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Per conto di Yury V.
Bukhman
Inviato: lunedi 15 gennaio 2001 23.00
A: [EMAIL PROTECTED]
Oggetto: how to put database into RAM?
Hi!
Background:
I have a moderately-sized (0.9G) database which serves as a backend to a
search engine. The search engine is kind of slow, because it has to run
multiple database queries for each user request (don't ask me why). In
order to speed things up, I am thinking of copying the entire database
into RAM. The users do not update it, they only search, so if the
server goes down, I can just copy the database from hard drive into RAM
again on startup.
Question:
what is the best way to put an entire database into RAM? I thought of
using HEAP tables, but they seem to have some limitations, e.g. not
allowing text column type. Is it possible to just copy an entire data
directory into RAM? Are there operating systems that allow this? I
currently run Linux, but could switch easily to another UNIX-like
system. Have anyone done something like this?
Any RTFMs or other pointers to literature will be appreciated.
Cheers!
Yury
---------------------------------------------------------------------
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
