Title: "Best Practices for Configuring Optimal MySQL Memory Usage" Date: 2016-11-19 15:19:00 Categories: [data base] tags: [mysql, mariadb, percona]
Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of memory – leaving defaults is one of the worst things you can do. But configuring it incorrectly can result in even worse performance (or even crashes).