# MariaDB 10 configuration for ViciHost
# HW Spec: 8-Core 2+Ghz, 24-GB RAM, RAID-1 SSD under /srv/mysql/data

# The following options will be passed to all MariaDB clients
[client]
# password  = your_password
 port       = 3306
 socket     = /var/run/mysqld/mysqld.sock

[mysqld]
log_bin=/var/lib/mysql/mariadb-bin
relay_log=/var/lib/mysql/mariadb-relay-bin
binlog_format=mixed
datadir = /var/lib/mysql
server-id       = 1
slave-skip-errors = 1032,1690,1062
slave_parallel_threads=2
slave-parallel-mode=optimistic
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysql.pid
sql_mode=NO_ENGINE_SUBSTITUTION
skip-external-locking
skip-name-resolve
connect_timeout=60
long_query_time=2
slow-query-log=1
slow-query-log-file=/var/log/mysql/mariadb-slow.log
log-slow-verbosity=query_plan,explain
max_connections=2000
key_buffer_size = 2G
max_allowed_packet = 16M
table_definition_cache=2048
table_open_cache = 512
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
query_cache_size=0M
query_cache_type=0
thread_concurrency=8
default-storage-engine=MyISAM
expire_logs_days = 3
concurrent_insert = 2
myisam_repair_threads = 4
myisam_recover_options=DEFAULT
tmpdir = /tmp/
thread_cache_size=100
join_buffer_size=20M
performance_schema=ON
innodb_buffer_pool_size=2G
innodb_log_file_size=20M
myisam_use_mmap=1
open_files_limit=24576
max_heap_table_size=256M
tmp_table_size=16M
key_cache_segments=64


[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log