Do you tune the default mariadb/mysql/postgresql configuration ?

[Alain De Vos]

Do you tune the default mariadb/mysql/postgresql configuration ? Which changes did you performed.

 

[xibo]

I enable remote login in pg_hba.conf, if that counts as tuning.

 

[SirDice]

Yes, for MySQL/MariaDB I typically use databases/mysqltuner then decide what might need tweaking and what not.

There is no one size fits all with regards to database configuration, it all depends on the database(s) and how it's being used. The database tuning of the (massive) database at $WEEKLY job will totally ruin the performance of your database for a small wordpress website for example.