MySQL and MariaDB are still the most used databases in the world. With everything we see on the web about them, it is important to be well informed to maximize the performance of MySQL / MariaDB.
Indeed, all the information available is not necessarily adapted to your situation. Instead of blindly following any suggestion, it is better to opt for a consulting service tailored to your use case.