Jcrespo has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/399115 )
Change subject: [WIP]mariadb: Add mysql 8.0-compatible template ...................................................................... [WIP]mariadb: Add mysql 8.0-compatible template Change-Id: I9330498242ef2b45160ee339ee3faa2bdd9583f2 --- A modules/role/templates/mariadb/mysqld_config/core-mysql.my.cnf.erb 1 file changed, 120 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/15/399115/1 diff --git a/modules/role/templates/mariadb/mysqld_config/core-mysql.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/core-mysql.my.cnf.erb new file mode 100644 index 0000000..acece1f --- /dev/null +++ b/modules/role/templates/mariadb/mysqld_config/core-mysql.my.cnf.erb @@ -0,0 +1,120 @@ +# Warning: This file is managed by Puppet! +# Production + +[client] +port = 3306 +socket = /run/mysqld/mysqld.sock +# ssl +#ssl-ca=/etc/ssl/certs/Puppet_Internal_CA.pem +#ssl-cert=/etc/mysql/ssl/cert.pem +#ssl-key=/etc/mysql/ssl/server.key +#ssl-verify-server-cert + +[mysqld] + +user = mysql +socket = /run/mysqld/mysqld.sock +port = 3306 +# extra_port = 3307 +basedir = /opt/mysql +datadir = /srv/sqldata +tmpdir = /srv/tmp +server_id = 1 + +# Always start in read_only mode. +# Master selection will be handled by cluster control. +#read_only = on + +log_bin +log_slave_updates +skip-external-locking +skip-name-resolve +#temp-pool + +# thread_handling = pool-of-threads +# thread_pool_stall_limit = 100 +# thread_pool_size = 32 +max_connections = 5000 +back_log = 500 +#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 +#use_stat_tables = preferably + +sync_binlog = 1 +binlog_cache_size = 1M +max_binlog_size = 1000M +binlog_format = ROW +# expire_logs_days = 7 +binlog_expire_logs_seconds = 604800 +slave_transaction_retries = 4294967295 +#sql-mode = IGNORE_BAD_TABLE_OPTIONS +tmp_table_size = 64M +max_heap_table_size = 64M + +table_open_cache = 50000 +table_definition_cache = 40000 +open-files-limit = 200000 +character_set_server = binary +character_set_filesystem = binary +collation_server = binary + +default-storage-engine = InnoDB +innodb_file_per_table = 1 +innodb_buffer_pool_size = 1G +innodb_log_file_size = 100M +innodb_flush_log_at_trx_commit = 1 +innodb_flush_method = O_DIRECT +innodb_thread_concurrency = 0 +innodb_io_capacity = 1000 +#innodb_stats_sample_pages = 16 +innodb_stats_method = nulls_unequal +#aria_pagecache_buffer_size = 1G +#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 + +# ssl +#ssl-ca=/etc/ssl/certs/Puppet_Internal_CA.pem +#ssl-cert=/etc/mysql/ssl/cert.pem +#ssl-key=/etc/mysql/ssl/server.key +#ssl-cipher=TLSv1.2 +# Enabling performance_schema (disabled by default in MariaDB10) +performance_schema = 1 +# downsizing performance schema memory usage: T99485 +#performance_schema_digests_size = -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 + +#optimizer_switch = 'mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on' +optimizer_switch = 'mrr=on,mrr_cost_based=on' + +[mysqldump] + +quick +max_allowed_packet = 32M + -- To view, visit https://gerrit.wikimedia.org/r/399115 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9330498242ef2b45160ee339ee3faa2bdd9583f2 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <jcre...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
