Springle has uploaded a new change for review. https://gerrit.wikimedia.org/r/175657
Change subject: MariaDB config tweakes for m1,m2,m3 ...................................................................... MariaDB config tweakes for m1,m2,m3 - Single buffer pool instance (>1 contributed to m2 lockup bug) - Enable extra port 3307 in line with prod cnf, for emergencies Change-Id: I43301d8cb5e77071629df806fb99e267b756787d --- M templates/mariadb/misc.my.cnf.erb 1 file changed, 11 insertions(+), 8 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/57/175657/1 diff --git a/templates/mariadb/misc.my.cnf.erb b/templates/mariadb/misc.my.cnf.erb index ce23bf9..a633193 100644 --- a/templates/mariadb/misc.my.cnf.erb +++ b/templates/mariadb/misc.my.cnf.erb @@ -6,14 +6,15 @@ [mysqld] -user = mysql -socket = /tmp/mysql.sock -port = 3306 -datadir = <%= @datadir %> -tmpdir = <%= @tmpdir %> -server_id = <%= @server_id %> -sql-mode = <%= @sql_mode %> -read_only = <%= @read_only %> +user = mysql +socket = /tmp/mysql.sock +port = 3306 +extra_port = 3307 +datadir = <%= @datadir %> +tmpdir = <%= @tmpdir %> +server_id = <%= @server_id %> +sql-mode = <%= @sql_mode %> +read_only = <%= @read_only %> log_bin log_slave_updates @@ -22,6 +23,7 @@ temp-pool max_connections = 500 +extra_max_connections = 10 max_connect_errors = 1000000000 max_allowed_packet = 16M connect_timeout = 3 @@ -51,6 +53,7 @@ default-storage-engine = InnoDB innodb_file_per_table = 1 innodb_buffer_pool_size = <%= (Float(@memorysize.split[0]) * 0.75).round %>G +innodb_buffer_pool_instances = 1 innodb_log_file_size = 1G innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT -- To view, visit https://gerrit.wikimedia.org/r/175657 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I43301d8cb5e77071629df806fb99e267b756787d Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Springle <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
