Why at least 1GB is recommended for droplets that use MySQL?
Hi,
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.
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.