[mysqld]
innodb_flush_method=O_DSYNC

#replication config.
#binlog-do-db = m2
#binlog-do-db = mor
#binlog-do-db = mor_mnp
#binlog-do-db = opensips
#server-id = 10
#server-id = 20
#auto_increment_increment = 10
#auto_increment_offset = 1
#auto_increment_offset = 2
#replicate-do-db = m2
#replicate-do-db = mor
#replicate-do-db = mor_mnp
#replicate-do-db = opensips
#binlog_format=MIXED
#log-bin = /var/lib/mysql/mysql-bin.log
#log-bin-index = /var/lib/mysql/master-log-bin.index
#relay-log = /var/lib/mysql/slave-relay.log
#relay-log-index = /var/lib/mysql/slave-relay-log.index
#slave-skip-errors=1061,1062,1213,1060,1032
#slave_transaction_retries=3600
#expire_logs_days = 3
#max_connections = 300
#slave_transaction_retries = 3600

skip-name-resolve
secure_file_priv=
innodb_file_per_table=1

query_cache_type=0
query_cache_limit=30M
query_cache_size=0

thread_stack=2M
thread_cache_size=8

max_allowed_packet=999M
key_buffer_size=62M
table_open_cache=1024
join_buffer_size=128M

max_heap_table_size=1024M

innodb_thread_concurrency=0
innodb_adaptive_hash_index=OFF
innodb_buffer_pool_size=2G
innodb_log_file_size=64M



datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
optimizer_switch = index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=off

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
user=mysql

# Semisynchronous Replication
# http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so

# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1

# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema

log-error=/var/log/mysqld.log

[mysqld_safe]
# mysqld_safe is not used in Linux with systemd
# leaving for compatibility reasons
# these settings have NO effect on Centos 7
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


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