6

Implement MySQL Configuration Profiles


Avatar
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

A