I've been looking in a lot of places so far but I couldn't find any articles about how much memory to allocate to MySQL based on server size.
I am about to deploy a website on a relatively small vserver with the following specs: 500 mb ram 20 gb SSD Ubuntu 14.04 64bit 1 virtual CPU (my provider doesn't specify speed).
With the server running idle (i.e website has no traffic), I get these values after rebooting:
It runs exclusively apache+mysql. The number of concurrent users is expected to be low for starters (<20).
What should be some sensible values for mysql's memory allocation for this case? And are there any other settings I can use to make sure the server resources are being used to their full extent?