linusnorton · February 11, 2020 20:06
diff --git a/50-server.cnf b/50-server.cnf
 [server]

 # this is only for the mysqld standalone daemon
 [mysqld]
 skip-log-bin

 #
 # * Basic Settings
 #
 user                    = mysql
 pid-file                = /run/mysqld/mysqld.pid
 socket                  = /run/mysqld/mysqld.sock
 #port                   = 3306
 basedir                 = /usr
 datadir                 = /var/lib/mysql
 tmpdir                  = /tmp
 lc-messages-dir         = /usr/share/mysql
 #skip-external-locking

 # Instead of skip-networking the default is now to listen only on
 # localhost which is more compatible and is not less secure.
 bind-address            = 127.0.0.1

 #
 # * Fine Tuning
 #
 #key_buffer_size        = 16M
 #max_allowed_packet     = 16M
 #thread_stack           = 192K
 #thread_cache_size      = 8
 # This replaces the startup script and checks MyISAM tables if needed
 # the first time they are touched
 #myisam_recover_options = BACKUP
 max_connections        = 500
 #table_cache            = 64
 #thread_concurrency     = 10

 #
 # * Query Cache Configuration
 #
 #query_cache_limit      = 1M
 query_cache_size        = 16M

 #
 # * Logging and Replication
 #
 # Both location gets rotated by the cronjob.
 # Be aware that this log type is a performance killer.
 # As of 5.1 you can enable the log at runtime!
 #general_log_file       = /var/log/mysql/mysql.log
 #general_log            = 1
 #
 # Error log - should be very few entries.
 #
 log_error = /var/log/mysql/error.log
 #
 # Enable the slow query log to see queries with especially long duration
 #slow_query_log_file    = /var/log/mysql/mariadb-slow.log
 #long_query_time        = 10
 #log_slow_rate_limit    = 1000
 #log_slow_verbosity     = query_plan
 #log-queries-not-using-indexes
 #
 # The following can be used as easy to replay backup logs or for replication.
 # note: if you are setting up a replication slave, see README.Debian about
 #       other settings you may need to change.
 #server-id              = 1
 log_bin                 = 0
 expire_logs_days        = 10
 #max_binlog_size        = 100M
 #binlog_do_db           = include_database_name
 #binlog_ignore_db       = exclude_database_name

 #
 # * Security Features
 #
 # Read the manual, too, if you want chroot!
 #chroot = /var/lib/mysql/
 #
 # For generating SSL certificates you can use for example the GUI tool "tinyca".
 #
 #ssl-ca = /etc/mysql/cacert.pem
 #ssl-cert = /etc/mysql/server-cert.pem
 #ssl-key = /etc/mysql/server-key.pem
 #
 # Accept only connections using the latest and most secure TLS protocol version.
 # ..when MariaDB is compiled with OpenSSL:
 #ssl-cipher = TLSv1.2
 # ..when MariaDB is compiled with YaSSL (default in Debian):
 #ssl = on

 #
 # * Character sets
 #
 # MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
 # utf8 4-byte character set. See also client.cnf
 #
 character-set-server  = utf8mb4
 collation-server      = utf8mb4_general_ci

 #
 # * InnoDB
 #
 # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
 # Read the manual for more InnoDB related options. There are many!
 innodb_read_io_threads=4
 innodb_write_io_threads=8                                    
 innodb_buffer_pool_instances=8
 innodb_buffer_pool_size=20G
 innodb_buffer_pool_load_at_startup=ON
 innodb_log_file_size = 32M #Small log files, more page flush
 innodb_log_files_in_group=2
 innodb_file_per_table=1
 innodb_log_buffer_size=8M
 innodb_flush_method=O_DIRECT
 innodb_flush_log_at_trx_commit=0
 innodb_io_capactity=10000
 skip-innodb_doublewrite
	[server]

	# this is only for the mysqld standalone daemon
	[mysqld]
	skip-log-bin

	#
	# * Basic Settings
	#
	user = mysql
	pid-file = /run/mysqld/mysqld.pid
	socket = /run/mysqld/mysqld.sock
	#port = 3306
	basedir = /usr
	datadir = /var/lib/mysql
	tmpdir = /tmp
	lc-messages-dir = /usr/share/mysql
	#skip-external-locking

	# Instead of skip-networking the default is now to listen only on
	# localhost which is more compatible and is not less secure.
	bind-address = 127.0.0.1

	#
	# * Fine Tuning
	#
	#key_buffer_size = 16M
	#max_allowed_packet = 16M
	#thread_stack = 192K
	#thread_cache_size = 8
	# This replaces the startup script and checks MyISAM tables if needed
	# the first time they are touched
	#myisam_recover_options = BACKUP
	max_connections = 500
	#table_cache = 64
	#thread_concurrency = 10

	#
	# * Query Cache Configuration
	#
	#query_cache_limit = 1M
	query_cache_size = 16M

	#
	# * Logging and Replication
	#
	# Both location gets rotated by the cronjob.
	# Be aware that this log type is a performance killer.
	# As of 5.1 you can enable the log at runtime!
	#general_log_file = /var/log/mysql/mysql.log
	#general_log = 1
	#
	# Error log - should be very few entries.
	#
	log_error = /var/log/mysql/error.log
	#
	# Enable the slow query log to see queries with especially long duration
	#slow_query_log_file = /var/log/mysql/mariadb-slow.log
	#long_query_time = 10
	#log_slow_rate_limit = 1000
	#log_slow_verbosity = query_plan
	#log-queries-not-using-indexes
	#
	# The following can be used as easy to replay backup logs or for replication.
	# note: if you are setting up a replication slave, see README.Debian about
	# other settings you may need to change.
	#server-id = 1
	log_bin = 0
	expire_logs_days = 10
	#max_binlog_size = 100M
	#binlog_do_db = include_database_name
	#binlog_ignore_db = exclude_database_name

	#
	# * Security Features
	#
	# Read the manual, too, if you want chroot!
	#chroot = /var/lib/mysql/
	#
	# For generating SSL certificates you can use for example the GUI tool "tinyca".
	#
	#ssl-ca = /etc/mysql/cacert.pem
	#ssl-cert = /etc/mysql/server-cert.pem
	#ssl-key = /etc/mysql/server-key.pem
	#
	# Accept only connections using the latest and most secure TLS protocol version.
	# ..when MariaDB is compiled with OpenSSL:
	#ssl-cipher = TLSv1.2
	# ..when MariaDB is compiled with YaSSL (default in Debian):
	#ssl = on

	#
	# * Character sets
	#
	# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
	# utf8 4-byte character set. See also client.cnf
	#
	character-set-server = utf8mb4
	collation-server = utf8mb4_general_ci

	#
	# * InnoDB
	#
	# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
	# Read the manual for more InnoDB related options. There are many!
	innodb_read_io_threads=4
	innodb_write_io_threads=8
	innodb_buffer_pool_instances=8
	innodb_buffer_pool_size=20G
	innodb_buffer_pool_load_at_startup=ON
	innodb_log_file_size = 32M #Small log files, more page flush
	innodb_log_files_in_group=2
	innodb_file_per_table=1
	innodb_log_buffer_size=8M
	innodb_flush_method=O_DIRECT
	innodb_flush_log_at_trx_commit=0
	innodb_io_capactity=10000
	skip-innodb_doublewrite