[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



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



skip_name_resolve




log_warnings                   = 2
                                 


character_set_server            = utf8                                                          
collation_server                = utf8_general_ci


myisam_recover                  = QUICK,BACKUP
key_buffer_size                 = 128M
concurrent_insert               = 2
read_buffer_size                = 8M
read_rnd_buffer_size            = 1M
sort_buffer_size                = 8M
bulk_insert_buffer_size         = 16M
max_allowed_packet              = 64M


max_connections                 = 600

thread_cache_size               = 600
wait_timeout                    = 600


open-files-limit                = 10000

table_cache                     = 3000
table_definition_cache          = 6000
tmp_table_size                  = 32M
max_heap_table_size             = 32M

query_cache_limit               = 128K
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    = 7
innodb_buffer_pool_size         = 7G



innodb_max_dirty_pages_pct      = 70
innodb_adaptive_flushing        = 1


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_use_native_aio		= 0

innodb_file_format		= BARRACUDA


innodb_autoinc_lock_mode	= 1
innodb_file_per_table           = 1
innodb_open_files               = 5000



auto_increment_increment        = 2


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          = 10000

log_slow_verbosity              = query_plan,innodb,explain


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


binlog_checksum = CRC32

master_verify_checksum     = 1



expire_logs_days                = 3
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
relay_log_recovery              = 1
relay_log_space_limit           = 0
log-slave-updates

binlog_annotate_row_events=ON
replicate_annotate_row_events=ON

binlog_format = MIXED
slave_exec_mode = IDEMPOTENT





slave-parallel-threads          = 20

binlog_commit_wait_count        = 20

binlog_commit_wait_usec         = 100000


myisam_sort_buffer_size         = 512M
myisam_recover                  = QUICK,BACKUP



max_error_count                 = 65535



slave_skip_errors=1062,1205

server-id                       = 9

auto_increment_offset           = 2
report-host                     = master02