|
Jordan |
By default MySQL is set to 151 connections for a small VPS 2C2G/4G is actually going to potentially allow MySQL to use more memory than it physically has.
There should be profiles that can be enabled for servers.
Small - 20 Connections + Innodb Buffer Pool 512M - 2G Servers
Medium - 40 Connections + Innodb Buffer Pool 1000M - 4G Servers
Large - 100 Connections + Innodb Buffer Pool 4000M - 8G Servers
Large - 200 Connections + Innodb Buffer Pool 12000M - 16G Servers