my.cnf
No OneTemporary
Actions

Size

3 KB

Referenced Files

None

Subscribers

None

my.cnf
View Options

	# -------------------------------------------------------------
	# MySQL configuration
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	# Project: Nasqueron
	# Created: 2015-04-21
	# License: Trivial work, not eligible to copyright
	# -------------------------------------------------------------

	# -------------------------------------------------------------
	# Clients
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

	[mysql]
	prompt = \u@\h [\d]>\_

	[mysqldump]
	quick
	max_allowed_packet = 32M

	# -------------------------------------------------------------
	# Server wrapper
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

	# -------------------------------------------------------------
	# Generic server settings
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	[mysqld]
	user = mysql
	pid-file = /var/run/mysqld/mysqld.pid
	socket = /var/run/mysqld/mysqld.sock
	port = 3306
	basedir = /usr
	tmpdir = /tmp
	lc-messages-dir = {{ share }}/mysql

	sql_mode = STRICT_ALL_TABLES
	explicit_defaults_for_timestamp

	log_bin
	log_basename = {{ nodename }}
	binlog_cache_size = 1M
	max_binlog_size = 1000M
	binlog_format = MIXED

	{% if use_zfs %}
	datadir = /var/db/mysql/mysql-root
	{% else %}
	datadir = /var/db/mysql
	{% endif %}

	# -------------------------------------------------------------
	# InnoDB / XtraDB configuration
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	default-storage-engine = InnoDB
	innodb_buffer_pool_size = 410M

	{% if use_zfs %}
	innodb_data_home_dir = /var/db/mysql/mysql-innodb-data
	innodb_log_group_home_dir = /var/db/mysql/mysql-innodb-logs

	innodb_file_per_table = off

	skip-innodb_doublewrite
	{% endif %}

	# -------------------------------------------------------------
	# Performance schema
	#
	# Wikimedia production servers on s3 have this configuration
	# with only 100MB of overhead. This is an acceptable cost
	# for a valuable information.
	#
	# Reference: https://phabricator.wikimedia.org/T99485
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	performance_schema = 1

	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

	# -------------------------------------------------------------
	# Applications configuration
	#
	# :: MediaWiki
	# :: Phabricator
	# :: OTRS
	#
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	# MediaWiki
	character_set_server = binary
	character_set_filesystem = binary
	collation_server = binary

	# Phabricator
	max_allowed_packet = 32M
	ft_stopword_file = {{ etc }}/mysql/stopwords.txt
	ft_min_word_len = 3
	ft_boolean_syntax = ' \|-><()~*:""&^'

	# OTRS
	key_buffer_size = 32M

File Metadata

Mime Type: text/plain
Expires: Fri, Feb 28, 20:14 (9 h, 53 m)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 2438083
Default Alt Text: my.cnf (3 KB)

my.cnfNo OneTemporaryActions

my.cnfView Options

File Metadata

Event Timeline

my.cnf
No OneTemporary
Actions

my.cnf
View Options