[mysqld]
user=mysql
datadir=/var/lib/mysql
tmpdir=/tmp
port=3306
socket=/var/lib/mysql/mysql.sock

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

character-set-server=utf8
skip-character-set-client-handshake

max_connections=151
table_open_cache=400
table_definition_cache=400
open_files_limit=1024

read_buffer_size=128K
read_rnd_buffer_size=256K
join_buffer_size=128K
sort_buffer_size=1024K

tmp_table_size=16M
max_heap_table_size=16M

#query_cache_size=0
#query_cache_type=1

log_output=FILE
slow_query_log=1
long_query_time=1.0
slow_query_log_file=/var/log/mysql/slow_query.log

#general_log=1
#general_log_file=/var/log/mysql/query.log

default_storage_engine=InnoDB
lower_case_table_names=1
innodb_buffer_pool_size=256M
innodb_log_files_in_group=2
innodb_log_file_size=64M
innodb_log_buffer_size=8M
innodb_data_file_path=ibdata1:256M:autoextend
innodb_autoextend_increment=256
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=1

sync_binlog=1
log-bin=mysql-bin
binlog-format=MIXED
max_binlog_size=128M
expire_logs_days=15

server-id=1

# FOR MASTER
#plugin-load=rpl_semi_sync_master=semisync_master.so
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=10

# FOR SLAVE
#plugin-load=rpl_semi_sync_slave=semisync_slave.so
#rpl_semi_sync_slave_enabled=1
#read_only

[mysql]
default-character-set=utf8
show-warnings
auto-rehash

[mysqld_safe]
log_error=/var/log/mysql/mysqld.log
pid_file=/var/run/mysqld/mysqld.pid