Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/213997
Change subject: Small configuration fix for pc1001 database
......................................................................
Small configuration fix for pc1001 database
tmpdir is now /a/tmp
Added load and dump of buffer pool on start/stop
Bug: T100301
Change-Id: Ife7da8febcf7898b4daba22f83348d3cd1e84bb5
---
M manifests/role/mariadb.pp
M templates/mariadb/parsercache.my.cnf.erb
2 files changed, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/97/213997/1
diff --git a/manifests/role/mariadb.pp b/manifests/role/mariadb.pp
index aa32554..ee14138 100644
--- a/manifests/role/mariadb.pp
+++ b/manifests/role/mariadb.pp
@@ -599,6 +599,7 @@
}
}
+# parsercache (pc) specific configuration
class role::mariadb::parsercache {
include standard
@@ -620,7 +621,11 @@
config => 'mariadb/parsercache.my.cnf.erb',
password => $passwords::misc::scripts::mysql_root_pass,
datadir => '/a/sqldata-cache',
+<<<<<<< HEAD
tmpdir => '/tmp',
+=======
+ tmpdir => '/a/tmp',
+>>>>>>> 4a117c9... Update of parsercache db servers to MariaDB 10 (#1)
}
# mysql monitoring access from tendril (db1011)
diff --git a/templates/mariadb/parsercache.my.cnf.erb
b/templates/mariadb/parsercache.my.cnf.erb
index 19a4079..f8f8e38 100644
--- a/templates/mariadb/parsercache.my.cnf.erb
+++ b/templates/mariadb/parsercache.my.cnf.erb
@@ -85,6 +85,10 @@
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
+
# Until kernel 3.16 http://www.spinics.net/lists/stable/msg61873.html
# At least, I think so. For now we need to avoid the an assertion failure on
Trusty w/ 3.13
innodb_use_native_aio = 0
--
To view, visit https://gerrit.wikimedia.org/r/213997
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ife7da8febcf7898b4daba22f83348d3cd1e84bb5
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
