config-db

#
# The Percona Server 5.7 configuration file.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# Recommended in standard MySQL setup
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES

# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock

[mysqld]
#
# * Basic Settings
#
user		= mysql
#pid-file        = /tmp/mysqld.pid
#socket          = /tmp/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
socket   = /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
event_scheduler = ON
default-authentication-plugin = mysql_native_password
skip-host-cache
skip-name-resolve
lower_case_table_names = 0
wait_timeout = 1800
interactive_timeout = 1800
net_read_timeout = 1800
net_write_timeout = 1800
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
# MyISAM #
key-buffer-size        = 16M
myisam-recover-options = BACKUP
#myisam-recover         = BACKUP

# SAFETY #
#max-connect-errors             = 10
#skip-name-resolve

# BINARY LOGGING #
expire-logs-days               = 7

performance_schema = ON
# CACHES AND LIMITS #
query-cache-type               = 0
query-cache-size               = 0
max-connections                = 2500
max_connect_errors             = 99999
#wait_timeout                    = 200
#connect_timeout                 = 100
max_user_connections           = 10000
thread-cache-size              = 150
open-files-limit               = 65535

# INNODB #
innodb_buffer_pool_load_at_startup  = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 1G
innodb-file-per-table          = 1

innodb_checksum_algorithm        = CRC32
innodb_write_io_threads	         = 4
innodb_read_io_threads		 = 4
innodb_thread_concurrency	 = 0
innodb-flush-log-at-trx-commit	 = 2
innodb-buffer-pool-size	         = 8G
innodb_buffer_pool_instances	 = 4
innodb_purge_threads		 = 4
innodb_io_capacity	         = 2000
innodb_io_capacity_max	         = 4000
innodb_stats_persistent_sample_pages = 300
innodb_max_dirty_pages_pct       = 80
innodb_max_dirty_pages_pct_lwm	 = 10
transaction_isolation	         = READ-COMMITTED
innodb_autoinc_lock_mode	 = 2
innodb_rollback_on_timeout	 = ON
innodb_file_format	         = barracuda
innodb_autoextend_increment	 = 64
optimizer_switch=index_merge_intersection=off
innodb_autoextend_increment	 = 512

max_allowed_packet		 = 1G
tmp_table_size		         = 32M
max_heap_table_size		 = 32M
sort_buffer_size		 = 512K
read-buffer-size		 = 512K
read-rnd-buffer-size		 = 512K
join_buffer_size		 = 512K
table_open_cache		 = 8096
table_definition_cache	         = 8096
bulk_insert_buffer_size		 = 20M
log_bin		                 = ON
binlog_format		         = ROW
binlog_row_image		 = MINIMAL
max_binlog_size		         = 1G
binlog_rows_query_log_events	 = ON
binlog_checksum		         = CRC32
server-id 		         = 65
#log_slave_updates                = TRUE
open_files_limit                  = 1048576
# LOGGING #
log-error                      = /var/log/mysql/mysql-error.log

[mysqldump]
quick
max_allowed_packet	= 16M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
no-auto-rehash
prompt = \u@\h:\d>


[misamchk]
key_buffer		= 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/