[mysqld]
log-warnings                    = 0
skip-name-resolve

socket                         = /var/lib/mysql/mysql.sock
pid-file                       = /var/lib/mysql/mysql.pid

innodb-file-format = Antelope
innodb-file-format-max = Antelope 

# TIMEOUTS #
interactive_timeout            = 3700
wait_timeout                   = 3700
connect_timeout                = 10

# Replication settings #
server-id                      = 1
log-bin                        = /var/lib/mysql/binarylog/binarylog-bin
relay-log                      = /var/lib/mysql/relaylog/relaylog-bin
auto-increment-increment       = 2
auto-increment-offset          = 1 
max_binlog_size                = 1G
expire_logs_days               = 14
master-retry-count             = 0  
slave-net-timeout              = 60
gtid_domain_id                 = 1

# Connections pools #
back_log                       = 3000
max_connections                = 3000
max_user_connections           = 2750


performance_schema      = 0
thread_handling         = pool-of-threads
thread_pool_size        = 8 
thread_pool_max_threads = 3000 
thread_cache_size       = 0
innodb_stats_on_metadata        = 0 
innodb_use_native_aio   = 1
innodb_use_fallocate    = 1 
innodb_adaptive_hash_index = 0
innodb_use_mtflush = 1 
innodb_mtflush_threads = 8 
innodb_sync_array_size = 1 
innodb_adaptive_flushing = 1
innodb_checksums = 1
innodb_checksum_algorithm = INNODB
innodb_doublewrite = 0
secure_auth = 0

##################

binlog_format=STATEMENT
default_storage_engine=InnoDB
transaction-isolation=REPEATABLE-READ


# SAFETY #
max-allowed-packet             = 4M
max-connect-errors             = 1000000

# CACHES AND LIMITS #

query_cache_type = 0
query-cache-size               = 0
query-cache-limit = 2M 
table-open-cache               = 8000 
open-files-limit = 65535

key_buffer_size = 16M #added
read_buffer_size = 262144
read_rnd_buffer_size = 524288
thread_stack = 262144

innodb-log-files-in-group      = 3
innodb-log-file-size           = 256M
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table         = 0
innodb-buffer-pool-size        = 4G
innodb_additional_mem_pool_size = 8388608

innodb_log_group_home_dir = /var/lib/mysql/logs/
innodb_buffer_pool_instances = 4


innodb_data_home_dir=
innodb_data_file_path=/dev/sda1:137204Mraw

innodb_io_capacity = 200  
innodb_io_capacity_max=1000 
innodb_write_io_threads = 4  
innodb_read_io_threads = 8  
innodb_log_buffer_size = 8M  
innodb_thread_concurrency = 6
innodb_lock_wait_timeout = 50
innodb_thread_sleep_delay = 20000
innodb_concurrency_tickets = 5000
open_files_limit=65535


# DATA STORAGE #
datadir                        = /var/lib/mysql/

# LOGGING #
slow-query-log                 = 1
long_query_time                = 2