No matter what you're using MySQL to do, more memory enables more transactions per second, more consistent quality of service, and reduced acquisition and licensing costs. Don't just take our word for it, though. Duplicate the test below, experience the difference, and
Since you don't need as many servers, you save on hardware, power, and VMware® licenses, which often cost more than a single server and hit your budget every year.
Why this approach significantly improves quality of service Virtualizing MySQL databases isn't about the number of VMs you can virtualize, but rather the number of VMs you can virtualize at an effective quality of service. Due to the inherent nature of their workload, virtualized MySQL databases tend to be spiky, and this natural variance increases as the number of VMs increases. The best way to improve service, then, is to eliminate variance and make workload performance more consistent.
More memory helps eliminate variance because it provides extra resources for the database to house and use active data. When data has to get swapped from storage to memory, performance is lost (the data went to storage because the memory was maxed out). In other words, housing hot, active data in memory is one of the best, most cost-effective ways to reduce workload variance and improve quality of service.
Tip: To really increase performance, we recommend using balloon drivers (you can install them within the VMware® software). Balloon drivers are helpful because they allow the software to see inside the VM and reallocate memory as needed. If you don't use balloon drivers, VMWare can't see what's going on within a VM. It only knows that it's allocated a set amount of resources to that VM â€“ not whether those resources are being fully utilized. Remove the barrier and watch your MySQL database automatically allocate memory to where it's most needed.
Memory is just one part of the MySQL performance equation, but it's perhaps the most important component for increasing performance and minimizing server sprawl and license costs. Contain your total build out by optimizing the hardware you purchase â€“ and get the highest level of performance.