Springle has uploaded a new change for review. https://gerrit.wikimedia.org/r/98142
Change subject: remove mysql 5.1 fb specific settings. needs further review for mariadb 5.5 once we know how it performs. ...................................................................... remove mysql 5.1 fb specific settings. needs further review for mariadb 5.5 once we know how it performs. Change-Id: I70a9a50823ffa25251f933bba7ef552ef1e37a35 --- M modules/mysql_wmf/templates/paresercache.my.cnf.erb 1 file changed, 6 insertions(+), 6 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/42/98142/1 diff --git a/modules/mysql_wmf/templates/paresercache.my.cnf.erb b/modules/mysql_wmf/templates/paresercache.my.cnf.erb index e70266d..049b3fd 100644 --- a/modules/mysql_wmf/templates/paresercache.my.cnf.erb +++ b/modules/mysql_wmf/templates/paresercache.my.cnf.erb @@ -44,9 +44,9 @@ temp-pool #rpl_transaction_enabled -reserved_super_connections=20 +#reserved_super_connections=20 -innodb-use-purge-thread=1 +#innodb-use-purge-thread=1 <% ram = memorysize.split[0]; ram = Float(ram) * 0.8; ram = ram.round; ram = String(ram) + "G"; %> @@ -60,19 +60,19 @@ innodb-old-blocks-time=1000 innodb-read-io-threads=16 innodb-thread-concurrency=0 -innodb-thread-lifo=1 +#innodb-thread-lifo=1 innodb-use-sys-malloc innodb-write-io-threads=8 innodb-checksums=1 innodb-flush-log-at-trx-commit=0 # disabling these helped prevent write stalls during heavier write loads with ssd's -innodb-flush-neighbors-on-checkpoint=0 -innodb-flush-neighbors-for-lru=0 +#innodb-flush-neighbors-on-checkpoint=0 +#innodb-flush-neighbors-for-lru=0 innodb_data_file_path=ibdata1:1500G -connection_recycle=1 +#connection_recycle=1 # Riiiveeeeer! # binlog_format=statement -- To view, visit https://gerrit.wikimedia.org/r/98142 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I70a9a50823ffa25251f933bba7ef552ef1e37a35 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
