diff options
author | Joseph Fernandes <josferna@redhat.com> | 2015-12-30 16:53:25 +0530 |
---|---|---|
committer | Dan Lambright <dlambrig@redhat.com> | 2016-09-22 13:28:34 -0700 |
commit | 7090cf287847a808d6d0225bc9110f44c3248e12 (patch) | |
tree | ffdd7025f3a3df674bec432d0fbfbdde02244bd1 | |
parent | c5426a13ad28fb2c6f0ed62404dbe60ea0dfaad2 (diff) |
tier/ctr/sql : Dafault values for sql cache and wal size
Setting default values for sql cache and wal size
cache : 12500 pages
wal : 25000 pages
1 pages - 4096 bytes
Change-Id: Iae3927e021af2e3f7617d45f84e81de3b7d93f1c
BUG: 1377864
Signed-off-by: Dan Lambright <dlambrig@redhat.com>
Reviewed-on: http://review.gluster.org/15536
Smoke: Gluster Build System <jenkins@build.gluster.org>
NetBSD-regression: NetBSD Build System <jenkins@build.gluster.org>
CentOS-regression: Gluster Build System <jenkins@build.gluster.org>
Reviewed-by: Milind Changire <mchangir@redhat.com>
-rw-r--r-- | libglusterfs/src/gfdb/gfdb_sqlite3.h | 4 | ||||
-rw-r--r-- | xlators/features/changetimerecorder/src/changetimerecorder.c | 4 | ||||
-rw-r--r-- | xlators/mgmt/glusterd/src/glusterd-volume-set.c | 12 |
3 files changed, 10 insertions, 10 deletions
diff --git a/libglusterfs/src/gfdb/gfdb_sqlite3.h b/libglusterfs/src/gfdb/gfdb_sqlite3.h index 4d70a60e431..52b84da251c 100644 --- a/libglusterfs/src/gfdb/gfdb_sqlite3.h +++ b/libglusterfs/src/gfdb/gfdb_sqlite3.h @@ -170,8 +170,8 @@ do {\ #define GF_SQL_DEFAULT_DBPATH "" #define GF_SQL_DEFAULT_PAGE_SIZE "4096" -#define GF_SQL_DEFAULT_CACHE_SIZE "1000" -#define GF_SQL_DEFAULT_WAL_AUTOCHECKPOINT "1000" +#define GF_SQL_DEFAULT_CACHE_SIZE "12500" +#define GF_SQL_DEFAULT_WAL_AUTOCHECKPOINT "25000" #define GF_SQL_DEFAULT_JOURNAL_MODE GF_SQL_JM_WAL #define GF_SQL_DEFAULT_SYNC GF_SQL_SYNC_OFF #define GF_SQL_DEFAULT_AUTO_VACUUM GF_SQL_AV_NONE diff --git a/xlators/features/changetimerecorder/src/changetimerecorder.c b/xlators/features/changetimerecorder/src/changetimerecorder.c index 933f496028c..4e4ea851a86 100644 --- a/xlators/features/changetimerecorder/src/changetimerecorder.c +++ b/xlators/features/changetimerecorder/src/changetimerecorder.c @@ -2441,11 +2441,11 @@ struct volume_options options[] = { }, { .key = {GFDB_SQL_PARAM_WAL_AUTOCHECK}, .type = GF_OPTION_TYPE_INT, - .default_value = "1000" + .default_value = "25000" }, { .key = {GFDB_SQL_PARAM_CACHE_SIZE}, .type = GF_OPTION_TYPE_INT, - .default_value = "1000" + .default_value = "12500" }, { .key = {GFDB_SQL_PARAM_PAGE_SIZE}, .type = GF_OPTION_TYPE_INT, diff --git a/xlators/mgmt/glusterd/src/glusterd-volume-set.c b/xlators/mgmt/glusterd/src/glusterd-volume-set.c index 53e8a441a2f..0c67135db3f 100644 --- a/xlators/mgmt/glusterd/src/glusterd-volume-set.c +++ b/xlators/mgmt/glusterd/src/glusterd-volume-set.c @@ -2839,29 +2839,29 @@ struct volopt_map_entry glusterd_volopt_map[] = { }, { .key = "features.ctr-sql-db-cachesize", .voltype = "features/changetimerecorder", - .value = "1000", + .value = "12500", .option = "sql-db-cachesize", .validate_fn = validate_ctr_sql_params, .op_version = GD_OP_VERSION_3_7_7, .description = "Defines the cache size of the sqlite database of " "changetimerecorder xlator." "The input to this option is in pages." - "Each page is 4096 bytes. Default value is 1000 " - "pages i.e ~ 4 MB. " + "Each page is 4096 bytes. Default value is 12500 " + "pages." "The max value is 262144 pages i.e 1 GB and " "the min value is 1000 pages i.e ~ 4 MB. " }, { .key = "features.ctr-sql-db-wal-autocheckpoint", .voltype = "features/changetimerecorder", - .value = "1000", + .value = "25000", .option = "sql-db-wal-autocheckpoint", .validate_fn = validate_ctr_sql_params, .op_version = GD_OP_VERSION_3_7_7, .description = "Defines the autocheckpoint of the sqlite database of " " changetimerecorder. " "The input to this option is in pages. " - "Each page is 4096 bytes. Default value is 1000 " - "pages i.e ~ 4 MB." + "Each page is 4096 bytes. Default value is 25000 " + "pages." "The max value is 262144 pages i.e 1 GB and " "the min value is 1000 pages i.e ~4 MB." }, |