A Very nice development ready mariadb config

here is a very minimal mariadb config for local development assuming you have 16GB of ram:

[client]
default-character-set = utf8mb4

[mariadb]
collation_server = utf8mb4_persian_ci
character_set_server = utf8mb4

[mariadb-client]
default-character-set = utf8mb4

[mysqld]
# InnoDB tuned for dev
innodb_buffer_pool_size = 1G
innodb_log_file_size = 128M
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT

# Connection limits
max_connections = 50
table_open_cache = 256
thread_cache_size = 8

# Temporary buffers
tmp_table_size = 64M
max_heap_table_size = 64M
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 1M

# Logging
slow_query_log = 0
general_log = 0

# Misc
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-name-resolve

So 😀 happy coding.