Here is my.cnf config example. # MariaDB 10 configuration for ViciBox # HW Spec: 8-Core 2+Ghz, 24-GB RAM, RAID-1 SSD under /srv/mysql/data #Here data mounted on seprate SSD drive which have Higher IO # The following options will be passed to all MariaDB clients [client] # password = your_password # port = 3306 # socket = /var/run/mysql/mysql.sock [mysqld] log_bin=/var/lib/mysql/mysql-bin relay_log=/var/lib/mysql/mysql-relay-bin binlog_format=mixed binlog_direct_non_transactional_updates=1 datadir = /srv/mysql/data server-id = 1 slave-skip-errors = 1032,1690,1062 slave_parallel_threads=20 slave-parallel-mode=optimistic slave_parallel_max_queued=5242880 port = 3306 socket = /var/run/mysql/mysql.sock sql_mode=NO_ENGINE_SUBSTITUTION skip-external-locking skip-name-resolve #no-auto-rehash connect_timeout=60 long_query_time=3 slow-query-log=1 slow-query-log-file=/var/lib/mysql/mysqld-slow.log log-slow-verbosity=query_plan,explain max_connections=2000 key_buffer_size = 8G max_all