0

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:

https://i.sstatic.net/JVGcn.png

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?

magicandre1981
  • 1,173
jonnybravo
  • 5

1 Answers1

2

Percona Configuration Wizard for MySQL is a nice tool to aid in MySQL configuration. It tries to provide a valid my.ini config file for your MySQL instance, based on many criteria like workload type, available RAM, CPU cores, MySQL version, etc. Requires registration.

sam_pan_mariusz
  • 2,241