Ottomata has submitted this change and it was merged.
Change subject: Analytics MySQL Meta instance: 4G innodb_buffer_pool_size 4
instances
......................................................................
Analytics MySQL Meta instance: 4G innodb_buffer_pool_size 4 instances
Also add NOTE about WF_JOBS.created_time index
Bug: T119646
Change-Id: I02be553922a40cbe427ad7c59ebdbb8022f13fac
---
M modules/role/manifests/analytics_cluster/oozie/server/database.pp
M templates/mariadb/analytics-meta.my.cnf.erb
2 files changed, 8 insertions(+), 1 deletion(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
diff --git a/modules/role/manifests/analytics_cluster/oozie/server/database.pp
b/modules/role/manifests/analytics_cluster/oozie/server/database.pp
index 3d1825e..c84f55f 100644
--- a/modules/role/manifests/analytics_cluster/oozie/server/database.pp
+++ b/modules/role/manifests/analytics_cluster/oozie/server/database.pp
@@ -15,6 +15,12 @@
require => Class['role::analytics_cluster::database::meta'],
}
+ # NOTE: on 2016-02-23, Otto and Joal
+ # added an INDEX on the oozie.WF_JOBS created_time field:
+ # ALTER TABLE oozie.WF_JOBS ADD INDEX (created_time);
+ # The WF_JOBS table was 38G, and oozie was getting stuck
+ # on long running queries sorting by created_time.
+
# cdh::oozie::database::mysql only ensures that
# the Oozie MySQL user has permissions to connect
# via localhost. If you plan on running
diff --git a/templates/mariadb/analytics-meta.my.cnf.erb
b/templates/mariadb/analytics-meta.my.cnf.erb
index 83c8a3c..2325026 100644
--- a/templates/mariadb/analytics-meta.my.cnf.erb
+++ b/templates/mariadb/analytics-meta.my.cnf.erb
@@ -34,7 +34,8 @@
innodb_log_file_size = 50M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 1
-innodb_buffer_pool_size = 1G
+innodb_buffer_pool_size = 4G
+innodb_buffer_pool_isntances = 4
query_cache_type = 1
query_cache_size = 16M
--
To view, visit https://gerrit.wikimedia.org/r/272813
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I02be553922a40cbe427ad7c59ebdbb8022f13fac
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Ottomata <[email protected]>
Gerrit-Reviewer: Ottomata <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
