Jcrespo has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370992 )

Change subject: labsdb: Set InnoDB as the default storage engine
......................................................................


labsdb: Set InnoDB as the default storage engine

To avoid excessive replica locking, use InnoDB as the default storage engine,
which will minimize lag issues when running DML/DDLs.

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

Approvals:
  jenkins-bot: Verified
  Jcrespo: Looks good to me, approved



diff --git a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
index 2ac7dd3..6a74eb2 100644
--- a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
@@ -66,7 +66,7 @@
 character_set_filesystem       = binary
 collation_server               = binary
 
-default-storage-engine         = Aria
+default-storage-engine         = InnoDB
 aria_pagecache_buffer_size     = <%= (Float(@memorysize.split[0]) * 
0.05).round %>G
 innodb_data_home_dir           = /srv/innodb
 innodb_file_per_table          = 0

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ida8de308c2a8d583b030bf6ffd9b199e1fb76560
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>

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

Reply via email to