[client]

port					 = 3306
socket					 = /tmp/mysql.sock


[mysqld]
###   User and Connection Related Parameters   ###

user					 = mysql
bind-address				 = 0.0.0.0
port					 = 3306
socket					 = /tmp/mysql.sock
max_connections				 = 500
max_user_connections			 = 500 
interactive_timeout			 = 100
wait_timeout				 = 100
skip-name-resolve
event_scheduler				 = 1

###   Cache/Buffer Related Parameters   ###

large-pages
table_open_cache                                = 5000
query_cache_type                                = 1
query_cache_size                                = 128M
query_cache_limit                               = 128M
key_buffer                                      = 128M
max_allowed_packet                              = 64M
# Thread Specific Values
sort_buffer_size                                = 16M
read_buffer_size                                = 16M
read_rnd_buffer_size                            = 16M
join_buffer_size                                = 16M
thread_cache_size                               = 64

###   Mysql Directory & Tables   ###

datadir					 = /data/mysql-5.6
tmp_table_size				 = 1024M
max_heap_table_size			 = 256M
open_files_limit			 = 16535

###   Innodb Related Parameters   ###

innodb_file_format 			 = barracuda
innodb_data_home_dir			 = /data/mysql-5.6
innodb_file_per_table			 = 1
#innodb_data_file_path			 = ibdata1:500M:autoextend
innodb_log_group_home_dir		 = /data/mysql-5.6
innodb_log_files_in_group		 = 2
innodb_log_file_size			 = 500M
innodb_buffer_pool_size		 	 = 20G


###   Log Related Parameteres   ###

log-error				 = /opt/mysql/log/mysqld.log
log-warnings				 = 0


###   Replication Related Parameters For Master   ###

skip-slave-start
slave-parallel-workers			 = 5

server_id				 = 3
relay-log                                = /data/relaylog/relay.log
relay-log-info-file                      = /data/relaylog/relay-log.info
relay-log-index                          = /data/relaylog/relay-log.index

relay-log-info-repository		 = TABLE
master-info-repository			 = TABLE

[mysqldump]
# Do not buffer the whole result set in memory before writing it to
# file. Required for dumping very large tables
quick
max_allowed_packet                       = 32M

[mysqld_safe]
log-warnings                             = 0
log-error                                = /opt/mysql/log/mysqld.log
open_files_limit                         = 10240