Strategies to cache from MySQL (or any DB I suppose)

[mike]

I know what HEAP tables are :)

That won't necessarily help either. I'd just be duplicating data to
put it into RAM so it didn't have to use disk I/O. But it would still
be using all the query mechanics, saving only a little bit of
processing because it wouldn't have to hit the disk. I'd have to keep
the memory in some sort of disk-based table too, since HEAPs are
volatile... it doesn't meet my original desire of saving trips to the
database by using a standard wrapper mechanism (which could be
distributed and work out all the mechanics itself.)

(One could also suggest the NDBClusters, since those currently run
only in RAM as well...)

- mike

On 11/8/05, Casper Langemeijer <casper at bcx.nl> wrote:
> Hi Mike,
>
> Have a look into MySQL HEAP tables. The HEAP storage engine allows
> you to store your tables into memory.
>
> If you want to cache raw data from mysql, it's probably best to cache it
> inside mysql. You can still do queries. Ofcourse it's not as fast as
> memcached because of query processing.