Aaron Schulz has uploaded a new change for review. https://gerrit.wikimedia.org/r/206145
Change subject: Changed production innodb_lock_wait_timeout from 50 => 30 ...................................................................... Changed production innodb_lock_wait_timeout from 50 => 30 * Queries should not stall this long. It encourages poor query design to rely on super high timeouts and also can make pile on effects if the blocked transaction holds locks itself. Change-Id: I873c9eba36af4c74cc20178197be585196bae748 --- M templates/mariadb/production.my.cnf.erb 1 file changed, 2 insertions(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/45/206145/1 diff --git a/templates/mariadb/production.my.cnf.erb b/templates/mariadb/production.my.cnf.erb index bd8a00a..cb8f43e 100644 --- a/templates/mariadb/production.my.cnf.erb +++ b/templates/mariadb/production.my.cnf.erb @@ -74,6 +74,7 @@ innodb_write_io_threads = 8 innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal +innodb_lock_wait_timeout = 30 aria_pagecache_buffer_size = 1G join_cache_level = 8 @@ -88,4 +89,4 @@ quick max_allowed_packet = 16M -#!includedir /etc/mysql/conf.d/ \ No newline at end of file +#!includedir /etc/mysql/conf.d/ -- To view, visit https://gerrit.wikimedia.org/r/206145 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I873c9eba36af4c74cc20178197be585196bae748 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Aaron Schulz <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
