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

[mysqld_safe]
socket			= /var/run/mysqld/mysqld.sock
pid-file                = /var/run/mysqld/mysqld.pid
nice			= -10

[mysqld]
user			= mysql
pid-file		= /var/run/mysqld/mysqld.pid
socket			= /var/run/mysqld/mysqld.sock
port			= 3306
basedir			= /usr
datadir			= /var/lib/mysql
tmpdir			= /dev/shm
lc-messages-dir		= /usr/share/mysql
symbolic-links		= 0
skip-external-locking
skip-name-resolve
explicit_defaults_for_timestamp

sql_mode		= NO_ENGINE_SUBSTITUTION

log-error               = /var/log/mysql/error.log
slow_query_log_file     = /var/log/mysql/mysql-slow.log
long_query_time		= 4
slow_query_log		= 1

local-infile            = 0
bind-address            = 196.52.8.11

key_buffer_size         = 128M
sort_buffer_size	= 2M
read_buffer_size	= 2M
join_buffer_size        = 20M
max_allowed_packet      = 400M
open_files_limit        = 100000
thread_stack            = 256K
thread_cache_size       = 48

myisam-recover-options  = BACKUP

max_connections         = 5000
max_user_connections    = 1000
back_log		= 256
max_connect_errors	= 9999999
net-write-timeout	= 180
net-read-timeout	= 90
max-allowed-packet	= 64M
open_files_limit	= 220000

table_open_cache        = 262000
table_definition_cache  = 4096

query_cache_type = 0
query_cache_size = 0

table_open_cache_instances = 128

expire_logs_days        = 30
max_binlog_size         = 400M

tmp_table_size = 4G
max_heap_table_size = 4G
bulk_insert_buffer_size = 2G

innodb_buffer_pool_size=20G
innodb_buffer_pool_instances=20
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_log_file_size=3G
innodb_log_buffer_size=12M
innodb_flush_log_at_trx_commit=0
innodb_thread_concurrency=0
innodb_file_per_table=ON
thread_pool_size=36
innodb_flush_method = O_DIRECT
innodb_open_files = 262000
innodb_checksum_algorithm=crc32
innodb_io_capacity=50000
innodb_io_capacity_max=65000
innodb_large_prefix     = true
innodb_support_xa=ON

#
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem


[mysqldump]
quick
quote-names
max_allowed_packet      = 1200M

[mysql]

[isamchk]
key_buffer              = 16M