0

What is the damage to the database if it uses high memory storage? Are there consequences for this use? Does it affect performance? I need to understand a lot about this problem to be able to create solutions to it

3
  • 1
    which nosql? Generally high memory usage is good for database as a in memory cache as its quicker than retrieving data of storage. If the there is swapping to disk of excessive virtual memory then that's generally bad. You need to describe problem significantly between to attempt a solution.
    – danblack
    Nov 26 '20 at 2:32
  • 1
    Presumably you've paid for your machine's memory, so using it is a good idea as @danblack says - my own personal rule of thumb is that if your database server is using ~ 85% of memory without (too much) swapping, you're doing OK. Having server resources sitting idle is a waste of money (IMHO). p.s. welcome to the forum!
    – Vérace
    Nov 26 '20 at 3:55
  • @Verace I think that's the general consensus for all of one's database server's hardware resources too, that sitting idle is a waste of money for something generally expensive. I'm definitely with you on that point.
    – J.D.
    Nov 26 '20 at 4:15
1

To add on to danblack's point, it's generally good for your server's memory to be mostly consumed by the database system because accessing data from memory is faster than disk, but if you don't have enough memory to support your database system's workload then you can run into performance issues when it needs to pull from disk or compensate in other ways.

If you updated your question with the specific issue you're trying to solve then we can provide more specific information, but if you're just generally asking then you don't have to worry too much about this until you run into performance issues. There's a lot of other things that can equally or more likely affect performance before memory provision does.

2
  • @danblack's Thank you for the answer, but I want to write a suggestion on one of the MONGODB issues! I chose a problem that it uses high memory for data storage., is that correct?
    – Ghe Eid
    Nov 26 '20 at 14:16
  • @GheEid if your question is "does MongoDB have performance issues because it uses a lot of memory?" then I'd say no. This is by design (as most database systems are designed to heavily rely on memory) and is normal. See here for more information on how it uses that memory: dba.stackexchange.com/questions/148395/…
    – J.D.
    Nov 26 '20 at 15:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.