[mysqld]

port = 3306
server-id = 2071321
datadir = /database/production_db/db

skip-name-resolve
skip-slave-start

log_output = file,table
log-warnings = 2

# log
general_log = 1
general_log_file = /database/production_db/db/db-dx.log

log-bin = /database/production_db/binlogs/db-dx-bin
log-error = /database/production_db/db/db-dx.err
pid-file = /database/production_db/db/db-dx.pid

myisam-recover = force,backup

federated
default-table-type = InnoDB

innodb_data_home_dir = /database/production_db/innodb-data
innodb_log_group_home_dir = /database/production_db/trans-logs
# innodb_log_arch_dir = /database/production_db/trans-logs

innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 120
# innodb_flush_method = fdatasync

innodb_thread_concurrency = 19
thread_cache_size = 200

query_cache_type = 1
query_cache_size = 100M
query_cache_limit = 1M

max_connections = 1000
table_cache = 2500
open_files_limit = 1000

slow_query_log = 1
slow_query_log_file = /database/production_db/db/db-dx-sq.log
# log-slow-queries = /database/production_db/db/db-dx-sq.log
long_query_time = 10
log-slow-admin-statements

innodb_buffer_pool_size = 1000M
innodb_additional_mem_pool_size = 100M

key_buffer_size = 8M
max_allowed_packet = 1M
sort_buffer_size = 512K
read_buffer_size = 512K

replicate_wild_do_table = CustomerDB01.%

innodb_log_files_in_group = 3
innodb_log_file_size = 250M
innodb_log_buffer_size = 8M

innodb_data_file_path = ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G;ibdata5:10G;ibdata6:10G;ibdata7:10G;ibdata8:10G;ibdata9:10G;ibdata10:10G;ibdata11:10G;ibdata12:10G;ibdata13:10G;ibdata14:10G;ibdata15:10G;ibdata16:10G;ibdata17:10G;ibdata18:10G;ibdata19:10G;ibdata20:10G;ibdata21:10G;ibdata22:10G;ibdata23:10G;ibdata24:10G;ibdata25:10G;ibdata26:10G;ibdata27:10G;ibdata28:10G;ibdata29:10G;ibdata30:10G;ibdata31:10G;ibdata32:10G;ibdata33:10G;ibdata34:10G;ibdata35:10G;ibdata36:10G;ibdata37:10G;ibdata38:10G;ibdata39:10G;ibdata40:10G