Jcrespo has submitted this change and it was merged.
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, 6 insertions(+), 1 deletion(-)
Approvals:
Jcrespo: Looks good to me, approved
jenkins-bot: Verified
diff --git a/manifests/role/mariadb.pp b/manifests/role/mariadb.pp
index aa32554..3a86514 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,7 @@
config => 'mariadb/parsercache.my.cnf.erb',
password => $passwords::misc::scripts::mysql_root_pass,
datadir => '/a/sqldata-cache',
- tmpdir => '/tmp',
+ tmpdir => '/a/tmp',
}
# 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: merged
Gerrit-Change-Id: Ife7da8febcf7898b4daba22f83348d3cd1e84bb5
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>
Gerrit-Reviewer: Jcrespo <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
