[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
#skip-name-resolve
back_log=50
local-infile=0
max_connections=100
max_user_connections=100
key_buffer_size=64M
myisam_sort_buffer_size=256M
myisam_max_sort_file_size=100G
read_buffer_size=131072
sort_buffer_size=2621440
table_open_cache=3K
table_cache=3K
table_definition_cache=12K
open_files_limit=6K
thread_cache_size=16K
thread_concurrency=0
low_priority_updates=1
concurrent_insert=ALWAYS
wait_timeout=28800
connect_timeout=50000
tmp_table_size=64M
max_heap_table_size=80M
max_allowed_packet=1024M
net_buffer_length=16384
net_write_timeout=30
net_read_timeout=30
net_retry_count=10
max_connect_errors=10
concurrent_insert=2
read_rnd_buffer_size=262144
bulk_insert_buffer_size=8M
long_query_time=5
query_cache_limit=148M
query_cache_min_res_unit=2K
query_cache_size=0
query_cache_type=0
query_prealloc_size=262144
query_alloc_block_size=65535
transaction_alloc_block_size=8192
transaction_prealloc_size=4096
max_write_lock_count=8
log-error
external-locking=FALSE
open_files_limit=50000
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
slow-query-log = 1
slow-query-log-file = /var/log/mariadb/mysql-slow.log
long_query_time = 1
# * Fine Tuning
#

#
# * Query Cache Configuration
#
# Cache only tiny result sets, so we can fit more in the query cache.

# for more write intensive setups, set to DEMAND or OFF
query_cache_type		= DEMAND
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
default_storage_engine	= InnoDB
sql_mode		= NO_ENGINE_SUBSTITUTION,TRADITIONAL
# you can't just change log file size, requires special procedure
default-storage-engine=MyISAM
innodb_log_file_size=16M
innodb_buffer_pool_size=934M
innodb_log_buffer_size=4M
innodb_file_per_table=ON
innodb_large_prefix=1
innodb_file_format=Barracuda
innodb_open_files=8000
innodb_io_capacity=8000
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=0
innodb_commit_concurrency=0
innodb_lazy_drop_table=1
innodb_lock_wait_timeout=120
innodb_corrupt_table_action=salvage
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_pct=100
innodb_stats_on_metadata=OFF
innodb_adaptive_hash_index=0
#
[mysqldump]
quick
quote-names
max_allowed_packet	= 512M
[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
#[isamchk]
#key_buffer		= 128M
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=384M
sort_buffer=384M
read_buffer=256M
write_buffer=256M


[myisamchk]
key_buffer=384M
sort_buffer=384M
read_buffer=256M
write_buffer=256M

[mysqlhotcopy]
interactive-timeout

#### Per connection configuration ####
sort_buffer_size=1M
join_buffer_size=1M
thread_stack=192K

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d