Why at least 1GB is recommended for droplets that use MySQL?

November 21, 2015 1.4k views


I'm using DO only to learn how to manage VPS, and I have only used shared servers so far, so sorry for my noob question.

Technical FAQ: setup page explains that:

"We recommend at least a 1GB Droplet for any server utilizing a MySQL database." Really? So if I would run 2 wordpress sites I would need about 2GB's of RAM?

Then why my shared hosting plan doesn't come crashing down with even smaller resources?
It has 768MB RAM, 4GB disk, 75% CPU speed, 2 wp-sites with 100-300 visits/day each, plus 2 wp testing installations and 1 gallery installation.
All wp's are using heavy premium wp-theme. However, W3 Total Cache is in use on production sites, and well tuned.

So there are 5 active MySQL's at use. Could it be, that these databases don't use my RAM at all?

Still, it doesn't make sense to me.

1 comment
  • I would say it depends on how mysql is used, what version and how large the databases. If the wordpress installations are fairly small then it probably doesn't tax much the mysql server (nor the system). Also, more recent versions of MySQL may have stiffer system requirements; I believe that a performance schema is installed as part of mysql 5.6 which may add some overhead.

    You also mentioned that you are using a shared hosting plan, which may also suggest that you may be borrowing resources from a larger host.

1 Answer

So if I would run 2 wordpress sites I would need about 2GB's of RAM?

No. 1 GB would be fine.

Even with multiple database-backed sites in a shared hosting environment (like your example), there is only one MySQL instance running. That one instance manages multiple databases. The MySQL engine is what needs the memory. The databases do not live in memory full-time.

I tried running MySQL on a 512 MB droplet. It didn't work well.

Have another answer? Share your knowledge.