Asher has uploaded a new change for review.
https://gerrit.wikimedia.org/r/72193
Change subject: slight myisam tuning for labsdbs, enable xtradb's
innodb_kill_idle_transaction feature
......................................................................
slight myisam tuning for labsdbs, enable xtradb's innodb_kill_idle_transaction
feature
Change-Id: Ic440515050d02cbda92ca808870b3b7a965def34
---
M modules/mysql_multi_instance/manifests/instance.pp
1 file changed, 3 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/93/72193/1
diff --git a/modules/mysql_multi_instance/manifests/instance.pp
b/modules/mysql_multi_instance/manifests/instance.pp
index a51b929..b4a76ab 100644
--- a/modules/mysql_multi_instance/manifests/instance.pp
+++ b/modules/mysql_multi_instance/manifests/instance.pp
@@ -116,9 +116,11 @@
'innodb-checksums' =>1,
'innodb_file_per_table' => true,
'innodb_locks_unsafe_for_binlog' => $innodb_locks_unsafe_for_binlog,
+ 'innodb_kill_idle_transaction' => 900,
'skip-external-locking' => true,
'skip-name-resolve' => true,
- 'key_buffer' => 1M,
+ 'key_buffer' => "1024M",
+ 'bulk_insert_buffer_size' => "256M",
'max_allowed_packet' => "16M",
'thread_stack' => "192K",
'thread_cache_size' => 300,
--
To view, visit https://gerrit.wikimedia.org/r/72193
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic440515050d02cbda92ca808870b3b7a965def34
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Asher <afeld...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
