{my.cnf} [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock datadir = /var/lib/mysql/ skip-external-locking innodb_buffer_pool_size = 25G key_buffer_size = 512M table_definition_cache = 16384 max_connections = 1000 log-error = /var/log/mariadb/mariadb.log log_warnings = 2 character-set-server = utf8 open-files-limit = 65535 sql-mode = "STRICT_ALL_TABLES,NO_AUTO_CREATE_USER" slow_query_log = 1 wait_timeout = 7200 innodb_log_file_size = 512M innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 180 innodb_flush_method = O_DIRECT innodb_file_per_table innodb_print_all_deadlocks = ON innodb_strict_mode = ON ignore-db-dirs=lost+found innodb_adaptive_hash_index = 0 userstat = 1 innodb_stats_persistent = OFF # 20210118SA Suggestion this may be causing semaphore crashes since 10.2 query_cache_size = 0 # 20210409SA - Takes some memory even though unused {from sub-files) [server] tmpdir = /tmp [server] log-error = /var/log/mariadb/mariadb.log log_warnings = 2 [mariadb] aria-encrypt-tables encrypt-binlog encrypt-tmp-disk-tables encrypt-tmp-files loose-innodb-encrypt-log loose-innodb-encrypt-tables