how much ram needs mongo in comparison with MySQL?
+1
A:
MongoDB does its best to keep as much useful information in RAM. MySQL generally does the same thing.
Both databases will use all of the RAM they have available.
Comparing the two is not easy, because it really depends on a lot of things. Things like your table structure and your data size and your indexes.
If you give MongoDB and MySQL the same amount of RAM, you will typically find the following:
- MongoDB will be very good at finding individual records. (like looking up a user or updating an entry)
- MySQL will be very good at loading and using sets of related data.
The performance will really be dictated by your usage of the database.
Gates VP
2010-07-15 01:51:36
To MongoDB, all data appears to be in memory--though this is virtual memory only, and the kernel has swapped some of it out to disk. Why do you think think there'd be a difference in MongoDB and MySQL performance given the same amount of RAM? MongoDB's indexes should be about as likely to be in RAM as MySQL's are.
mjs
2010-07-16 18:22:52