Tag Info

New answers tagged

1

The answer as always is: it depends ;) With a bit of simplification: Indexes and recently read (and written) documents are kept in RAM until that RAM is needed for something else. So wether your data is read from RAM or from file pretty much depends wether RAM on the MongoDb node(s) is sufficient to keep the index and at least part of your data (called the ...


1

I wrote these posts Mar 28, 2014 : MySQL not releasing memory Apr 24, 2012 : How costly is opening and closing of a DB connection? May 24, 2011 : What are user connections - when are the created and destroyed? and discussed the many buffers that are allocated for each connection. They are part of RAM and not encapsulated within the cache. Since the ...


1

Your comment about intensive dropping and creating and the notice you received regarding increasing max_locks_per_transaction hint that you're dropping and creating many objects in the same transaction. Each of those results in a lock, which each requires a small amount of shared memory. Because of this, max_locks_per_transaction limits the number of locks ...



Top 50 recent answers are included