# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

sql_mode =NO_ENGINE_SUBSTITUTION

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
skip-external-locking
skip_name_resolve
innodb_buffer_pool_size = 205G
bind-address=0.0.0.0
skip-innodb_adaptive_hash_index
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
 basedir = /usr/local/mysql
 datadir = /mysql_data/mysql
 log_error=/usr/local/mysql/mysql_error.log
 port = 3306
 socket = /var/run/mysqld/mysqld.sock 

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

innodb_data_home_dir = /mysql_data/mysql
innodb_data_file_path = ibdata1:10M;ibdata2:5M:autoextend
innodb_log_group_home_dir = /mysql_data/mysql
innodb_log_file_size = 500M
innodb_additional_mem_pool_size = 100M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 250

innodb_file_per_table

innodb_log_buffer_size    = 64M
innodb_thread_concurrency = 500
innodb_buffer_pool_instance =32
innodb_flush_method =O_DIRECT
thread_cache_size         = 2000
#thread_concurrency        = 32
query_cache_min_res_unit  = 512
query_cache_limit         = 100M
query_cache_size          = 0
#query_cache_size          = 512M
thread_cache_size         = 250
table_open_cache          = 40000
table_definition_cache =40000
long_query_time           = 1

query_cache_type          = 0
innodb_io_capacity =4000
innodb_write_io_threads =64
innodb_read_io_threads =64
innodb_table_locks=0
transaction-isolation ='READ-COMMITTED'

# Fine Tuning
max_allowed_packet        = 32M
thread_stack              = 192K
myisam-recover            = BACKUP
max_connections           = 10000
open_files_limit          = 16384
group_concat_max_len =8192
#innodb_force_recovery=2

# Buffers and Caches
#table_cache               = 4096
max_tmp_tables             =128
tmp_table_size            = 32M
max_heap_table_size       = 32M
sort_buffer_size          = 48M
read_buffer_size          = 1M
read_rnd_buffer_size      = 24M
join_buffer_size          = 24M
key_buffer_size           = 128M
character_set_server      = utf8
collation_server          = utf8_general_ci
sql_mode=NO_ENGINE_SUBSTITUTION 
event_scheduler=on

#setting for server as slave
server-id = 16
#replicate-do-db=bob_live
#replicate-do-db=jabong_social
#replicate-do-db=conny_live
#slave_compressed_protocol=1
slave-skip-errors = 1062,1032
#skip-slave-start


#setting master db
sync_binlog               = 0
expire_logs_days          = 5
max_binlog_size           = 512M
log-slave-updates
binlog_format=mixed

log-bin =/mysql_data/mysql_binlog/mysql-bin

#Odd Even rule
auto_increment_increment = 2
auto_increment_offset = 1

#Extended tuning configuration
table_open_cache_instances = 8
thread_cache_size= 3000
read_buffer_size= 1M
read_rnd_buffer_size= 4M
sort_buffer_size= 4M