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

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.
 
Here my postgresql.conf for ZFS,
Code: 
max_connections = 100            # (change requires restart)
shared_buffers = 1GB            # min 128kB
work_mem = 8MB                # min 64kB
maintenance_work_mem = 1GB        # min 64kB
dynamic_shared_memory_type = posix    # the default is usually the first option
full_page_writes = off            # recover from partial page writes
max_wal_size = 2GB
min_wal_size = 80MB
effective_cache_size = 2GB
log_destination = 'syslog'
log_timezone = 'Europe/Brussels'
datestyle = 'iso, mdy'
timezone = 'Europe/Brussels'
lc_messages = 'C.UTF-8'            # locale for system error message
lc_monetary = 'C.UTF-8'            # locale for monetary formatting
lc_numeric = 'C.UTF-8'            # locale for number formatting
lc_time = 'C.UTF-8'            # locale for time formatting
default_text_search_config = 'pg_catalog.english'
shared_preload_libraries = 'timescaledb'
 
Here my my.cnf for mariadb,zfs,

Code: 
[client-server]
port    = 3306
socket    = /var/run/mysql/mysql.sock

[mariadbd]
innodb_doublewrite = 0
innodb_file_per_table = 1

!includedir /usr/local/etc/mysql/conf.d/
 
You must log in or register to reply here.
Back
Top