Link You Today
Bookmark your Free, Libre software & tech link

data base Best Practices for Configuring Optimal MySQL Memory Usage

mariadb, mysql, 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).