NVMe SSD Config for Server

[Masetrix]

Do you have pointers for good config for MySQL 8.x with server having 32GB RAM?

Beginners start here:

MySQL Performance Tuning: Tips, Scripts and Tools

With MySQL, common configuration mistakes can create severe performance problems. If you misconfigure just one of the many config parameters, it can

haydenjames.io

 

[Xon]

Optimal config is based on individual user's mysql usage requirements and server configuration and involve long term monitoring to derive. Usually for my paid server optimisation clients it involves up to 2-4 days of work and analysis at minimum. No quick answers/configs really.

Well beyond "enable per-table files", and "ensure innodb buffer size isn't the default 128mb".

Why the hell it took till MySQL 8 before those some of the insanely bad defaults I do not know.