Jaime's testing config
ActivePublic
Actions

Authored by jcrespo on Mar 19 2018, 10:02 AM.

Tags

None

Referenced Files

	F15878883: Jaime's testing config
	Mar 19 2018, 10:02 AM

Subscribers

None

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

	[mysqld]

	# administrative options
	user = mysql
	socket = /run/mysqld/mysqld.sock
	port = 3306
	extra-port = 3307
	datadir = /srv/sqldata
	basedir = /opt/wmf-mariadb101
	tmpdir = /srv/tmp
	# prevent imports/exports to arbitrary dirs
	secure_file_priv = /var/lib/mysqld
	server-id = 1

	skip-external-locking
	skip-name-resolve
	temp-pool

	# Always start in read_only mode.
	# Master selection will be handled by orchestration.
	read_only = 1

	# thread and connection handling
	# Mariadb only
	thread_handling = pool-of-threads
	# Mariadb only
	thread_pool_stall_limit = 100
	# Mariadb only
	thread_pool_size = 64
	# Mariadb only
	thread_pool_max_threads = 2000
	max_connections = 10000
	back_log = 500
	# MariaDB only
	extra_max_connections = 10
	max_connect_errors = 1000000000
	max_allowed_packet = 32M
	connect_timeout = 3
	query_cache_size = 0
	query_cache_type = 0
	event_scheduler = 1
	log-warnings = 0
	thread_stack = 192K
	thread_cache_size = 300
	interactive_timeout = 28800
	wait_timeout = 3600
	transaction-isolation = REPEATABLE-READ

	# binary log an replication options
	log-bin
	log-slave-updates
	sync-binlog = 1
	binlog-cache-size = 1M
	max-binlog_size = 1000M
	binlog-format = STATEMENT
	expire-logs-days = 7
	slave-transaction-retries = 4294967295

	# table limits
	tmp-table-size = 64M
	max-heap-table-size = 64M
	table-open-cache = 50000
	table-definition-cache = 40000
	open-files-limit = 200000

	# optimizer options
	# MariaDB only
	sql-mode = IGNORE_BAD_TABLE_OPTIONS
	optimizer_switch = 'mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on'
	# MariaDB only
	use-stat-tables = preferably

	# charsets and collations
	character_set_server = binary
	character_set_filesystem = binary
	collation_server = binary

	# InnoDB options
	default-storage-engine = InnoDB
	innodb_file_per_table = 1
	innodb_buffer_pool_size = 12G
	innodb_log_file_size = 2G
	innodb_flush_log_at_trx_commit = 1
	innodb_flush_method = O_DIRECT
	innodb_thread_concurrency = 0
	innodb_io_capacity = 1000
	# MariaDB only
	innodb_stats_sample_pages = 16
	innodb_stats_method = nulls_unequal
	# MariaDB only
	aria_pagecache_buffer_size = 1G
	# MariaDB only
	join_cache_level = 8

	# dump and load innodb buffer at start and stop
	innodb_buffer_pool_load_at_startup = 1
	innodb_buffer_pool_dump_at_shutdown = 1

	# profiling and metrics
	# Enabling performance_schema (disabled by default in MariaDB10)
	performance_schema = 1
	# downsizing performance schema memory usage: T99485
	performance_schema_max_thread_instances = 500
	performance_schema_max_cond_instances = 1000
	performance_schema_accounts_size = 300
	performance_schema_hosts_size = 300
	performance_schema_events_statements_history_size = 10
	performance_schema_events_statements_history_long_size = 1000
	performance_schema_events_waits_history_size = 10
	performance_schema_events_waits_history_long_size = 1000
	performance_schema_events_stages_history_size = 10
	performance_schema_events_stages_history_long_size = 1000
	performance_schema_max_mutex_instances = 5000
	performance_schema_max_rwlock_instances = 2000
	performance_schema_max_socket_instances = 500
	performance_schema_max_table_instances = 1000

	[mysqldump]

	quick
	max_allowed_packet = 32M

Event Timeline

jcrespo created this paste.Mar 19 2018, 10:02 AM

Jaime's testing configActivePublicActions

Event Timeline

Jaime's testing config
ActivePublic
Actions