Re: MM deadlock [was: Re: arca-vm-8...]

Andrea Arcangeli
1999-01-14T22:43:38Z

On Thu, 14 Jan 1999, Mike Jagdis wrote:

> With either the shm used is normally "large" with respect to
> available physical memory (i.e. everything that isn't needed by
> processes under your normal load) because the database engines
> use it to cache data (this is why they want raw IO - there's no
> point the OS caching the data as well).

Ah but if what you say is true the db server shm issue raised by Stephen
is completly pointless. If the shm memory is used as _cache_ for the data
there's _no_ one point to swapout it out in first place. So when using the
shm for caching purposes the db server _must_ set the SHM_LOCK flag on the
shm memory using shmctl.

Andrea Arcangeli