awesome-mysql-performance VS lnmp

To tune manually, you could start with the following links: 1. MySQL Health Checks https://releem.com/blog/mysql-health-checks 2. Documentation on how to tune parameters: - https://releem.com/docs/getstarted - https://releem.com/docs/mysql-performance-parameters 3. Curated list of awesome links related to MySQL Performance Tuning https://github.com/Releem/awesome-mysql-performance

Hey, We've published github repo on MySQL Performance Tuning https://github.com/Releem/awesome-mysql-performance , hope it'll be helpful to you.

Try to use MySQLTuner script to get recommendations and create my.cnf manually.We've created a curated list of awesome links related to MySQL / MariaDB / Percona configuration tuning: https://github.com/Releem/awesome-mysql-performance

But the best tool is understanding how the different part of the system and usage affects performance, and decide how to proceed based on information that might or not be in the database server itself. There are optimizations that go to hardware, OS, replication, database structure/indexes, frequently done queries, and probably more. And you need to take into account that the database and the system around it is not static, in particular how you use it, so some in production monitoring may be helpful. There are plenty of articles and presentations that tells you which variables and settings you should focus on depending on how you use the db (this could be an starting list), do some frequent queries analysis, and even use some good mysql monitoring like PMM that could give you more hints.

We have collected an amazing list of articles and resources that are related to MySQL configuration performance tuning.

There are an array of resources available to learn about MySQL configuration. MySQL has hundreds of configuration options, but for many server needs, only a handful are critical. The tuning will vary depending on workload and hardware, but DBAs that familiarize themselves with best practices (for their specific version of MySQL) will better be able to understand and solve performance issues. Releem has collected an amazing list of articles and resources that are related to MySQL / MariaDB / Percona configuration.

This could be one of such script, but it does more than that (in fact a lot for me!)