Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/372366 )

Change subject: dbstore3.my.cnf: Reduce pool size
......................................................................

dbstore3.my.cnf: Reduce pool size

This is just a proposal to reduce the general buffer pool size for all
the shards 3GB, so we can get s7 copied to dbstore2001 and get this over
with. So at least we have all the shards replicating, and we can do fine
tunning later.

If we reduce 3GB per shard, that give us 3GB*6 shards = 18GB available
so we can include s7

Again, this is just a proposal to move forward with the data copy so we
can have dbstore2001 completely finished.

Bug: T168409
Change-Id: Id19ae268f2c264730ed3f276edaeef1da5167b6d
---
M modules/role/templates/mariadb/mysqld_config/dbstore3.my.cnf.erb
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/66/372366/1

diff --git a/modules/role/templates/mariadb/mysqld_config/dbstore3.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/dbstore3.my.cnf.erb
index 50fde34..80ab89b 100644
--- a/modules/role/templates/mariadb/mysqld_config/dbstore3.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/dbstore3.my.cnf.erb
@@ -45,7 +45,7 @@
 collation_server         = binary
 
 innodb_file_per_table          = 1
-innodb_buffer_pool_size        = 15G
+innodb_buffer_pool_size        = 12G
 innodb_log_file_size           = 4G
 innodb_flush_log_at_trx_commit = 0
 innodb_flush_method            = O_DIRECT

-- 
To view, visit https://gerrit.wikimedia.org/r/372366
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id19ae268f2c264730ed3f276edaeef1da5167b6d
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui <maroste...@wikimedia.org>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to