Jcrespo has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/328671 )
Change subject: dbstore: configuration changes to make InnoDB the main storage ...................................................................... dbstore: configuration changes to make InnoDB the main storage These will be applied when all dbstores are using exclusivelly InnoDB, and not TokuDB anymore. Bug: T130128 Change-Id: I4046efd8909dfc71c99547906e8d2682335b9049 --- M templates/mariadb/dbstore.my.cnf.erb 1 file changed, 5 insertions(+), 6 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/71/328671/1 diff --git a/templates/mariadb/dbstore.my.cnf.erb b/templates/mariadb/dbstore.my.cnf.erb index 8b9c9cb..332fb17 100644 --- a/templates/mariadb/dbstore.my.cnf.erb +++ b/templates/mariadb/dbstore.my.cnf.erb @@ -49,7 +49,7 @@ table_open_cache = 50000 table_definition_cache = 50000 -default-storage-engine = Aria +default-storage-engine = InnoDB # InnoDB file-per-table + TokuDB love those file descriptors open-files-limit = 400000 @@ -59,7 +59,7 @@ collation_server = binary innodb_file_per_table = 1 -innodb_buffer_pool_size = 24G +innodb_buffer_pool_size = 100G innodb_log_file_size = 4G innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT @@ -68,7 +68,6 @@ innodb_stats_sample_pages = 16 innodb_stats_method = nulls_unequal innodb_locks_unsafe_for_binlog = 1 -aria_pagecache_buffer_size = 16G # dump and load innodb buffer at start and stop innodb_buffer_pool_load_at_startup = 1 @@ -77,11 +76,11 @@ optimizer_switch='engine_condition_pushdown=on,optimize_join_buffer_size=on' join_cache_level = 8 -plugin-load = ha_tokudb -tokudb_cache_size = 24G +#plugin-load = ha_tokudb +#tokudb_cache_size = 24G # Tokudb will stop working when there is less than 1% of free disk space # (5% by default) -tokudb_fs_reserve_percent = 1 +#tokudb_fs_reserve_percent = 1 skip-slave-start slave_transaction_retries = 4294967295 -- To view, visit https://gerrit.wikimedia.org/r/328671 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I4046efd8909dfc71c99547906e8d2682335b9049 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
