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."          },  | 
