mysql/mariadb optimization

[hami]

How i can optimiz mysql/mariadb on Directadmin?
My mysql/mariadb Version is 10.4.13

 

[Zhenyapan]

You can add your customizations to /etc/my.cnf.d/server.cnf or to /etc/my.cnf

 

[hami]

What is the best practices optimization configuration?

 

[Zhenyapan]

it's individual for each situation, different DBs causes different load.
you can start from mysqltuner recommendations.

 

[factor]

What is the best practices optimization configuration?

Again no silver bullet.

You might learn something from using mysqltuner

GitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. - major/MySQLTuner-perl

github.com