[client]
socket                          = /var/lib/mysql/mysql.sock



[mysqld]

user                            = mysql
pid-file                        = /var/lib/mysql/mysqld.pid
socket                          = /var/lib/mysql/mysql.sock
port                            = 3306
basedir                         = /usr
datadir                         = /u01/data
tmpdir                          = /dev/shm
slave_load_tmpdir               = /tmp


skip_name_resolve




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

log_warnings			= 2



character_set_server            = utf8                                                          
collation_server                = utf8_general_ci


myisam_recover                  = QUICK,BACKUP
myisam_sort_buffer_size         = 512M

key_buffer_size                 = 64M
concurrent_insert               = 2
read_buffer_size                = 8M

read_rnd_buffer_size            = 2M
sort_buffer_size                = 8M
bulk_insert_buffer_size         = 16M
max_allowed_packet              = 64M
max_connections                 = 400



thread_cache_size               = 400
wait_timeout                    = 600


open-files-limit                = 10000

table_cache                     = 4000

table_definition_cache          = 6000


tmp_table_size                  = 64M
max_heap_table_size             = 64M


query_cache_limit               = 256K
query_cache_size                = 64M

query_cache_strip_comments=ON


default_storage_engine          = InnoDB
sql_mode                        = NO_ENGINE_SUBSTITUTION
innodb_data_home_dir            = /u01/data
innodb_data_file_path           = ibdata1:100M:autoextend
innodb_log_group_home_dir       = /u01/tlog

innodb_log_files_in_group       = 8

innodb_log_file_size            = 64M


innodb_log_buffer_size          = 16M

innodb_buffer_pool_instances    = 5
innodb_buffer_pool_size         = 5G





innodb_max_dirty_pages_pct      = 70

innodb-buffer-pool-dump-at-shutdown = 1
innodb-buffer-pool-load-at-startup  = 1










innodb_io_capacity		= 2000
innodb_read_io_threads          = 8
innodb_write_io_threads         = 8
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method             = O_DIRECT
innodb_file_per_table           = 1

innodb_open_files               = 3000




innodb_adaptive_flushing	= 1

innodb_file_format              = BARRACUDA


innodb_autoinc_lock_mode	= 1

innodb_use_native_aio           = 0

innodb_print_all_deadlocks      = 1


replicate-ignore-table		= hostworks.backup_config



slow_query_log_file             = /u01/blog/slow.log
slow_query_log                  = 1

long_query_time                 = 10

min_examined_row_limit          = 1000

log_slow_verbosity              = query_plan,innodb,explain

log_slow_rate_limit             = 1000
log_queries-not_using_indexes
log_slow_admin_statements

log_slow_slave_statements

log_bin                         = /u01/blog/mysql-bin
sync_binlog                     = 1
log_bin_index                   = /u01/blog/mysql-bin.index
expire_logs_days                = 10
max_binlog_size                 = 100M
relay-log                       = /u01/blog/relay-bin
relay-log-index                 = /u01/blog/relay-bin.index
relay-log-info-file             = /u01/blog/relay-bin.info

max_relay_log_size		= 256M


binlog_annotate_row_events=ON
replicate_annotate_row_events=ON 

binlog_format = MIXED
slave_exec_mode = IDEMPOTENT





slave-parallel-threads         = 20




max_error_count                 = 65535

optimizer_switch		= 'index_merge=off'
read_only=ON






master_verify_checksum     = 1
binlog_checksum            = CRC32





slave_skip_errors=1062,1205


server-id                       = 10
report-host                     = slave01