Remix.run Logo
giancarlostoro an hour ago

MySQL doesnt eat up all 8GB of my system when I need to query a table with indexed values, MongoDB seems to eat it all up.

hilariously 9 minutes ago | parent | next [-]

If the data is < ram size and if you read that data again and its off disk again its the slowest it can possibly be, there's a reason most databases implement a buffer cache (actually making writes insanely faster as well) but yeah, MySQL is generally not a very good operational database with all the ones I have tinkered with.

vscode-rest 43 minutes ago | parent | prev [-]

You paid one hundred bucks for that eight gb of ram, do you really want it to just sit there unused?

giancarlostoro 38 minutes ago | parent [-]

No, but my manager was wondering why our website was slowing to a crawl.

vscode-rest 37 minutes ago | parent [-]

Is the DB on the same host as the web server?

hilariously 8 minutes ago | parent [-]

It is more likely they did not leave enough overhead for the host operating system, which is a classic issue.