#
# /etc/my.cnf.d/server.cnf
#
# Configuration for MariaDB server.
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
user=mysql
datadir=/var/lib/mysql/DB
# datadir=/var/db/mysql
bind-address=127.0.0.1
character-set-server=utf8
#skip-character-set-client-handshake
skip-name-resolve

expire_logs_days=7
#log_output="NONE"
log_output="FILE"
#log_output="FILE,TABLE"
#general-log=0
general-log=1
general-log-file=/var/lib/mysql/log/mysql
#general-log-file=/var/db/mysql/log/mysql
log_error=/var/lib/mysql/log/mysql-error
#log_error=/var/db/mysql/log/mysql-error
#slow_query_log=0
slow_query_log=1
slow_query_log_file = /var/lib/mysql/log/mysql-slow.log
#slow_query_log_file = /var/db/mysql/log/mysql-slow.log
max_binlog_size=100M
sync_binlog=1
binlog_format=mixed
log_bin=/var/lib/mysql/log/mysql-bin
#log_bin=/var/db/mysql/log/mysql-bin
relay_log=/var/lib/mysql/log/mysql-relay
relay_log=/var/db/mysql/log/mysql-relay
log_slave_updates

key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8

innodb_buffer_pool_size = 768M
innodb_log_file_size = 128M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1
innodb_support_xa=1
innodb_log_files_in_group = 7
innodb_autoextend_increment=64
innodb_file_per_table

plugin-load = handlersocket.so;semisync_master.so;semisync_slave.so

#rpl_semi_sync_master_enabled =1
#rpl_semi_sync_slave_enabled = 1
#rpl_semi_sync_master_timeout=30

# this is only for embedded server
[embedded]

# This group is only read by MariaDB-5.5 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mysqld-5.5]

# These two groups are only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

[mariadb-5.5]