Alistair MacDonald writes:
>
>
> On Sat, 2 Oct 1999, randyboy wrote:
> > I'm looking into the prospects of running a MySQL db out a RAM disk. I
> > guess the simplest way of doing that would be to copy the db files into
> > memory and starting MySQL using the files in memory. However, I run into
> > problems with having to update both the db files in memory and the db
> > files on disk while the system is running. I suppose that also requires
>
> This sounds as though you are wanting to run the database from the ram
> disk purely for performance reasons. If so, it is unlikely to gain you
> much, apart from the complexity of synchronising the data. Increasing the
> amount of buffer/cache space would probably achieve what you want with
> fewer drawbacks.
>
> Alistair
>
Hi,
In MySQL 3.23 you can create in-memory HEAP tables which are extremely
fast for lookups. You might be interested in this option also..
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
