[client]
port                                    = 3306
socket                                  = /var/run/mysqld/mysqld.sock

[mysqld]
user                                    = mysql
port                                    = 3306
pid-file                                = /db/mysql/mysqld.pid
basedir                                 = /usr/local/mysql
datadir                                 = /db/mysql
tmpdir                                  = /local/dbtmp
socket                                  = /var/run/mysqld/mysqld.sock
server-id                               = 6872
skip-external-locking
key_buffer_size                         = 1M
max_allowed_packet                      = 1G 
thread_cache_size                       = 256
table_open_cache                        = 2048
table_definition_cache                  = 512
sort_buffer_size                        = 1M
read_buffer_size                        = 256K
read_rnd_buffer_size                    = 256K
join_buffer_size                        = 256K
myisam-recover-options                  = BACKUP,FORCE
myisam_sort_buffer_size                 = 512M
tmp_table_size                          = 64M
max_heap_table_size                     = 64M
wait_timeout                            = 28800
connect_timeout                         = 5
max_connections                         = 1000
query_cache_type                        = 0
query_cache_size                        = 0
transaction_isolation                   = READ-COMMITTED
binlog_format                           = ROW

local_infile                            = 0
skip-symbolic-links

log-output                              = FILE
log-error                               = /db/mysql/mysql-error.log
log-error-verbosity                     = 1
slow-query-log                          = 1
slow-query-log-file                     = /local/mysql/slow-queries.log
long-query-time                         = 30
#log-queries-not-using-indexes

# if this is a slave uncomment the following
read_only                               = 1

binlog_cache_size                       = 2097152
#log-slave-updates
#skip-slave-start
#expire-logs-days                        = 8
#slave_net_timeout                      = 300

log_bin                                 = /dblog/mysql/db-master-bin.nnnnnn
log_bin_index                           = /dblog/mysql/db-master-bin.index
master-info-file                        = /dblog/mysql/master.info

relay-log                               = /dblog/mysql/db-relay-bin.nnnnn
relay-log-index                         = /dblog/mysql/db-relay-bin.index
relay-log-info-file                     = /dblog/mysql/relay-log.info

#5.6
table_open_cache_instances              = 8
innodb_flush_neighbors                  = 0
explicit_defaults_for_timestamp         = 1
innodb_buffer_pool_load_at_startup      = ON
innodb_buffer_pool_dump_at_shutdown     = ON
#innodb_log_compressed_pages            = false

default_storage_engine                  = InnoDB
sql_mode                                = STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
innodb_log_file_size                    = 2G
innodb_log_files_in_group               = 2
innodb_buffer_pool_instances            = 16
innodb_buffer_pool_size                 = 200G
innodb_log_buffer_size                  = 16M
innodb_file_per_table                   = 1
innodb_open_files                       = 8192 
innodb_io_capacity                      = 10000
#innodb_use_sys_malloc                  = 0
innodb_flush_method                     = O_DIRECT
innodb_flush_log_at_trx_commit          = 0
innodb_doublewrite                      = 0
innodb_read_ahead_threshold             = 64
innodb_write_io_threads                 = 8
innodb_read_io_threads                  = 8
innodb_old_blocks_pct                   = 10
innodb_purge_threads                    = 1
innodb_max_purge_lag                    = 150000
innodb_stats_on_metadata                = 0

innodb_page_cleaners                            = 4
innodb_adaptive_flushing                        = 1
innodb_adaptive_hash_index                      = 0
sync_binlog                                     = 0
relay-log-info-repository                       = table
master-info-repository                          = table
relay-log-recovery                              = 1
relay-log-purge                                 = 1
innodb_buffer_pool_dump_pct                     =100
innodb_numa_interleave                          = 1
log-timestamps                                  = SYSTEM
secure-file-priv                                = NULL

performance-schema=ON
performance-schema-instrument='%=OFF'
performance-schema-consumer-events-stages-current=OFF
performance-schema-consumer-events-stages-history=OFF
performance-schema-consumer-events-stages-history-long=OFF
performance-schema-consumer-events-statements-current=OFF
performance-schema-consumer-events-statements-history=OFF
performance-schema-consumer-events-statements-history-long=OFF
performance-schema-consumer-events-transactions-current=OFF
performance-schema-consumer-events-transactions-history=OFF
performance-schema-consumer-events-transactions-history-long=OFF
performance-schema-consumer-events-waits-current=OFF
performance-schema-consumer-events-waits-history=OFF
performance-schema-consumer-events-waits-history-long=OFF
performance-schema-consumer-global-instrumentation=OFF
performance-schema-consumer-thread-instrumentation=OFF
performance-schema-consumer-statements-digest=OFF

[mysql]
no-auto-rehash

[mysqld_safe]
malloc-lib                                      = /usr/lib/libjemalloc.so
flush_caches                                    = 1
log-error                                       = /db/mysql/mysql-error.log
mysqld-safe-log-timestamps                      = SYSTEM