Hi,
I have the following settings:
HA off
log_file_size_partitions = 10485760 (10MB)
snapshot_trigger_size = 536870912 (500MB)
snapshots_to_keep = 1
Yet there are a little over 300 10MB files in the data directory for one of the DB taking therefore about 3GB worth of disk space.
Could you explain why? I was expecting no more than 500MB worth of space taken by these files.
Thanks
Your seeing 300 log files for one partition database on a leaf? (i.e., if your database is named test, you will end up with test_X named partition database on the leaves. Each of those will have their own log stream that should be ~500 MB worth of logs).
Are you able to share the ls output of the datadir/logs and datadir/snapshot directory so we can check?
-Adam
data/logs
-rw------- 1 celer-uat celer-uat 10485760 Sep 10 05:25 db_client_uat_core_server_0_log_v1_140800
-rw------- 1 celer-uat celer-uat 10485760 Sep 10 09:28 db_client_uat_core_server_0_log_v1_143360
-rw------- 1 celer-uat celer-uat 10485760 Sep 10 12:56 db_client_uat_core_server_0_log_v1_145920
-rw------- 1 celer-uat celer-uat 10485760 Sep 10 16:23 db_client_uat_core_server_0_log_v1_148480
-rw------- 1 celer-uat celer-uat 10485760 Sep 10 19:55 db_client_uat_core_server_0_log_v1_151040
-rw------- 1 celer-uat celer-uat 10485760 Sep 11 03:32 db_client_uat_core_server_0_log_v1_153600
-rw------- 1 celer-uat celer-uat 10485760 Sep 11 13:27 db_client_uat_core_server_0_log_v1_156160
-rw------- 1 celer-uat celer-uat 10485760 Sep 11 19:38 db_client_uat_core_server_0_log_v1_158720
-rw------- 1 celer-uat celer-uat 10485760 Sep 11 22:08 db_client_uat_core_server_0_log_v1_161280
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 00:40 db_client_uat_core_server_0_log_v1_163840
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 03:15 db_client_uat_core_server_0_log_v1_166400
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 05:51 db_client_uat_core_server_0_log_v1_168960
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 08:25 db_client_uat_core_server_0_log_v1_171520
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 11:01 db_client_uat_core_server_0_log_v1_174080
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 13:41 db_client_uat_core_server_0_log_v1_176640
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 16:42 db_client_uat_core_server_0_log_v1_179200
-rw------- 1 celer-uat celer-uat 10485760 Sep 12 20:08 db_client_uat_core_server_0_log_v1_181760
-rw------- 1 celer-uat celer-uat 10485760 Sep 13 23:54 db_client_uat_core_server_0_log_v1_184320
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 04:00 db_client_uat_core_server_0_log_v1_186880
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 06:34 db_client_uat_core_server_0_log_v1_189440
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 08:56 db_client_uat_core_server_0_log_v1_192000
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 11:26 db_client_uat_core_server_0_log_v1_194560
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 13:48 db_client_uat_core_server_0_log_v1_197120
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 16:09 db_client_uat_core_server_0_log_v1_199680
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 16:55 db_client_uat_core_server_0_log_v1_202240
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 18:33 db_client_uat_core_server_0_log_v1_204800
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 21:11 db_client_uat_core_server_0_log_v1_207360
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 00:54 db_client_uat_core_server_0_log_v1_209920
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 03:56 db_client_uat_core_server_0_log_v1_212480
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 05:22 db_client_uat_core_server_0_log_v1_215040
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 07:16 db_client_uat_core_server_0_log_v1_217600
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 09:03 db_client_uat_core_server_0_log_v1_220160
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 10:51 db_client_uat_core_server_0_log_v1_222720
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 12:43 db_client_uat_core_server_0_log_v1_225280
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 14:30 db_client_uat_core_server_0_log_v1_227840
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:12 db_client_uat_core_server_0_log_v1_230400
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:57 db_client_uat_core_server_0_log_v1_232960
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 18:19 db_client_uat_core_server_0_log_v1_235520
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 19:45 db_client_uat_core_server_0_log_v1_238080
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 21:39 db_client_uat_core_server_0_log_v1_240640
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 00:15 db_client_uat_core_server_0_log_v1_243200
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 02:24 db_client_uat_core_server_0_log_v1_245760
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 04:16 db_client_uat_core_server_0_log_v1_248320
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 06:10 db_client_uat_core_server_0_log_v1_250880
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 07:59 db_client_uat_core_server_0_log_v1_253440
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 09:43 db_client_uat_core_server_0_log_v1_256000
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 11:15 db_client_uat_core_server_0_log_v1_258560
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 12:41 db_client_uat_core_server_0_log_v1_261120
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 14:31 db_client_uat_core_server_0_log_v1_263680
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 15:58 db_client_uat_core_server_0_log_v1_266240
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 17:25 db_client_uat_core_server_0_log_v1_268800
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 18:01 db_client_uat_core_server_0_log_v1_271360
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 19:09 db_client_uat_core_server_0_log_v1_273920
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 20:19 db_client_uat_core_server_0_log_v1_276480
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 21:27 db_client_uat_core_server_0_log_v1_279040
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 22:50 db_client_uat_core_server_0_log_v1_281600
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 00:09 db_client_uat_core_server_0_log_v1_284160
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 01:29 db_client_uat_core_server_0_log_v1_286720
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 02:48 db_client_uat_core_server_0_log_v1_289280
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 04:05 db_client_uat_core_server_0_log_v1_291840
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 05:23 db_client_uat_core_server_0_log_v1_294400
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 06:43 db_client_uat_core_server_0_log_v1_296960
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 08:03 db_client_uat_core_server_0_log_v1_299520
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 09:25 db_client_uat_core_server_0_log_v1_302080
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 10:47 db_client_uat_core_server_0_log_v1_304640
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 12:08 db_client_uat_core_server_0_log_v1_307200
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:27 db_client_uat_core_server_0_log_v1_309760
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 14:26 db_client_uat_core_server_0_log_v1_312320
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:27 db_client_uat_core_server_0_log_v1_314880
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 19:58 db_client_uat_core_server_2_log_v1_140800
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 23:57 db_client_uat_core_server_2_log_v1_143360
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 03:55 db_client_uat_core_server_2_log_v1_145920
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 05:43 db_client_uat_core_server_2_log_v1_148480
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 08:18 db_client_uat_core_server_2_log_v1_151040
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 10:55 db_client_uat_core_server_2_log_v1_153600
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 13:27 db_client_uat_core_server_2_log_v1_156160
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 15:33 db_client_uat_core_server_2_log_v1_158720
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:50 db_client_uat_core_server_2_log_v1_161280
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 18:20 db_client_uat_core_server_2_log_v1_163840
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 20:26 db_client_uat_core_server_2_log_v1_166400
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 22:53 db_client_uat_core_server_2_log_v1_168960
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 01:19 db_client_uat_core_server_2_log_v1_171520
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 03:38 db_client_uat_core_server_2_log_v1_174080
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 06:13 db_client_uat_core_server_2_log_v1_176640
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 08:56 db_client_uat_core_server_2_log_v1_179200
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 10:56 db_client_uat_core_server_2_log_v1_181760
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 12:55 db_client_uat_core_server_2_log_v1_184320
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 15:03 db_client_uat_core_server_2_log_v1_186880
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 17:06 db_client_uat_core_server_2_log_v1_189440
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 18:02 db_client_uat_core_server_2_log_v1_192000
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 20:05 db_client_uat_core_server_2_log_v1_194560
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 22:00 db_client_uat_core_server_2_log_v1_197120
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 00:15 db_client_uat_core_server_2_log_v1_199680
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 02:27 db_client_uat_core_server_2_log_v1_202240
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 04:39 db_client_uat_core_server_2_log_v1_204800
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 06:51 db_client_uat_core_server_2_log_v1_207360
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 09:06 db_client_uat_core_server_2_log_v1_209920
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 11:19 db_client_uat_core_server_2_log_v1_212480
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:29 db_client_uat_core_server_2_log_v1_215040
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 14:26 db_client_uat_core_server_2_log_v1_217600
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:29 db_client_uat_core_server_2_log_v1_220160
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 08:48 db_client_uat_core_server_4_log_v1_281600
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 10:35 db_client_uat_core_server_4_log_v1_284160
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 12:26 db_client_uat_core_server_4_log_v1_286720
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 14:18 db_client_uat_core_server_4_log_v1_289280
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:04 db_client_uat_core_server_4_log_v1_291840
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:54 db_client_uat_core_server_4_log_v1_294400
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 18:10 db_client_uat_core_server_4_log_v1_296960
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 19:42 db_client_uat_core_server_4_log_v1_299520
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 21:28 db_client_uat_core_server_4_log_v1_302080
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 23:17 db_client_uat_core_server_4_log_v1_304640
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 01:06 db_client_uat_core_server_4_log_v1_307200
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 03:04 db_client_uat_core_server_4_log_v1_309760
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 05:39 db_client_uat_core_server_4_log_v1_312320
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 08:18 db_client_uat_core_server_4_log_v1_314880
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 10:14 db_client_uat_core_server_4_log_v1_317440
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 11:44 db_client_uat_core_server_4_log_v1_320000
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 13:17 db_client_uat_core_server_4_log_v1_322560
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 14:57 db_client_uat_core_server_4_log_v1_325120
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 16:33 db_client_uat_core_server_4_log_v1_327680
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 17:50 db_client_uat_core_server_4_log_v1_330240
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 19:08 db_client_uat_core_server_4_log_v1_332800
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 21:01 db_client_uat_core_server_4_log_v1_335360
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 22:36 db_client_uat_core_server_4_log_v1_337920
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 00:15 db_client_uat_core_server_4_log_v1_340480
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 01:58 db_client_uat_core_server_4_log_v1_343040
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 03:36 db_client_uat_core_server_4_log_v1_345600
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 05:20 db_client_uat_core_server_4_log_v1_348160
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 06:59 db_client_uat_core_server_4_log_v1_350720
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 08:40 db_client_uat_core_server_4_log_v1_353280
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 10:19 db_client_uat_core_server_4_log_v1_355840
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 11:59 db_client_uat_core_server_4_log_v1_358400
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:31 db_client_uat_core_server_4_log_v1_360960
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 14:26 db_client_uat_core_server_4_log_v1_363520
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:31 db_client_uat_core_server_4_log_v1_366080
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 19:31 db_client_uat_core_server_6_log_v1_140800
-rw------- 1 celer-uat celer-uat 10485760 Sep 14 23:45 db_client_uat_core_server_6_log_v1_143360
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 03:42 db_client_uat_core_server_6_log_v1_145920
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 05:35 db_client_uat_core_server_6_log_v1_148480
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 08:14 db_client_uat_core_server_6_log_v1_151040
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 10:48 db_client_uat_core_server_6_log_v1_153600
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 13:32 db_client_uat_core_server_6_log_v1_156160
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 15:51 db_client_uat_core_server_6_log_v1_158720
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 16:50 db_client_uat_core_server_6_log_v1_161280
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 18:08 db_client_uat_core_server_6_log_v1_163840
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 19:34 db_client_uat_core_server_6_log_v1_166400
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 21:28 db_client_uat_core_server_6_log_v1_168960
-rw------- 1 celer-uat celer-uat 10485760 Sep 15 23:26 db_client_uat_core_server_6_log_v1_171520
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 01:19 db_client_uat_core_server_6_log_v1_174080
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 03:17 db_client_uat_core_server_6_log_v1_176640
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 05:15 db_client_uat_core_server_6_log_v1_179200
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 07:16 db_client_uat_core_server_6_log_v1_181760
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 09:10 db_client_uat_core_server_6_log_v1_184320
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 10:52 db_client_uat_core_server_6_log_v1_186880
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 12:23 db_client_uat_core_server_6_log_v1_189440
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 14:23 db_client_uat_core_server_6_log_v1_192000
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 15:54 db_client_uat_core_server_6_log_v1_194560
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 17:38 db_client_uat_core_server_6_log_v1_197120
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 18:19 db_client_uat_core_server_6_log_v1_199680
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 20:02 db_client_uat_core_server_6_log_v1_202240
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 21:31 db_client_uat_core_server_6_log_v1_204800
-rw------- 1 celer-uat celer-uat 10485760 Sep 16 23:20 db_client_uat_core_server_6_log_v1_207360
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 01:08 db_client_uat_core_server_6_log_v1_209920
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 02:44 db_client_uat_core_server_6_log_v1_212480
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 04:21 db_client_uat_core_server_6_log_v1_215040
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 05:58 db_client_uat_core_server_6_log_v1_217600
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 07:35 db_client_uat_core_server_6_log_v1_220160
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 09:11 db_client_uat_core_server_6_log_v1_222720
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 10:48 db_client_uat_core_server_6_log_v1_225280
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 12:23 db_client_uat_core_server_6_log_v1_227840
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:36 db_client_uat_core_server_6_log_v1_230400
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 14:26 db_client_uat_core_server_6_log_v1_232960
-rw------- 1 celer-uat celer-uat 10485760 Sep 17 13:36 db_client_uat_core_server_6_log_v1_235520
-rw------- 1 celer-uat celer-uat 5242880 Aug 28 01:13 db_client_uat_core_server_log_v1_10240
-rw------- 1 celer-uat celer-uat 5242880 Aug 28 10:46 db_client_uat_core_server_log_v1_11520
-rw------- 1 celer-uat celer-uat 5242880 Aug 28 20:39 db_client_uat_core_server_log_v1_12800
-rw------- 1 celer-uat celer-uat 5242880 Aug 29 07:21 db_client_uat_core_server_log_v1_14080
-rw------- 1 celer-uat celer-uat 5242880 Aug 29 18:05 db_client_uat_core_server_log_v1_15360
-rw------- 1 celer-uat celer-uat 5242880 Aug 31 04:22 db_client_uat_core_server_log_v1_16640
-rw------- 1 celer-uat celer-uat 5242880 Aug 31 14:22 db_client_uat_core_server_log_v1_17920
-rw------- 1 celer-uat celer-uat 5242880 Sep 1 01:04 db_client_uat_core_server_log_v1_19200
-rw------- 1 celer-uat celer-uat 5242880 Sep 1 08:58 db_client_uat_core_server_log_v1_20480
-rw------- 1 celer-uat celer-uat 5242880 Sep 1 19:31 db_client_uat_core_server_log_v1_21760
-rw------- 1 celer-uat celer-uat 5242880 Sep 2 05:24 db_client_uat_core_server_log_v1_23040
-rw------- 1 celer-uat celer-uat 5242880 Sep 2 14:34 db_client_uat_core_server_log_v1_24320
-rw------- 1 celer-uat celer-uat 5242880 Sep 3 00:30 db_client_uat_core_server_log_v1_25600
-rw------- 1 celer-uat celer-uat 5242880 Sep 3 10:34 db_client_uat_core_server_log_v1_26880
-rw------- 1 celer-uat celer-uat 5242880 Sep 3 20:37 db_client_uat_core_server_log_v1_28160
-rw------- 1 celer-uat celer-uat 5242880 Sep 4 06:32 db_client_uat_core_server_log_v1_29440
-rw------- 1 celer-uat celer-uat 5242880 Sep 4 16:15 db_client_uat_core_server_log_v1_30720
-rw------- 1 celer-uat celer-uat 5242880 Sep 5 01:59 db_client_uat_core_server_log_v1_32000
-rw------- 1 celer-uat celer-uat 5242880 Sep 6 23:40 db_client_uat_core_server_log_v1_33280
-rw------- 1 celer-uat celer-uat 5242880 Sep 7 10:25 db_client_uat_core_server_log_v1_34560
-rw------- 1 celer-uat celer-uat 5242880 Sep 7 20:43 db_client_uat_core_server_log_v1_35840
-rw------- 1 celer-uat celer-uat 5242880 Sep 8 07:27 db_client_uat_core_server_log_v1_37120
-rw------- 1 celer-uat celer-uat 5242880 Sep 8 17:27 db_client_uat_core_server_log_v1_38400
-rw------- 1 celer-uat celer-uat 5242880 Sep 9 03:31 db_client_uat_core_server_log_v1_39680
-rw------- 1 celer-uat celer-uat 5242880 Sep 9 13:25 db_client_uat_core_server_log_v1_40960
-rw------- 1 celer-uat celer-uat 5242880 Sep 9 23:29 db_client_uat_core_server_log_v1_42240
-rw------- 1 celer-uat celer-uat 5242880 Sep 10 09:12 db_client_uat_core_server_log_v1_43520
-rw------- 1 celer-uat celer-uat 5242880 Sep 10 19:13 db_client_uat_core_server_log_v1_44800
-rw------- 1 celer-uat celer-uat 5242880 Sep 11 05:17 db_client_uat_core_server_log_v1_46080
-rw------- 1 celer-uat celer-uat 5242880 Sep 11 14:22 db_client_uat_core_server_log_v1_47360
-rw------- 1 celer-uat celer-uat 5242880 Sep 11 22:48 db_client_uat_core_server_log_v1_48640
-rw------- 1 celer-uat celer-uat 5242880 Sep 12 08:52 db_client_uat_core_server_log_v1_49920
-rw------- 1 celer-uat celer-uat 5242880 Sep 12 18:54 db_client_uat_core_server_log_v1_51200
-rw------- 1 celer-uat celer-uat 5242880 Sep 14 04:43 db_client_uat_core_server_log_v1_52480
-rw------- 1 celer-uat celer-uat 5242880 Sep 14 14:07 db_client_uat_core_server_log_v1_53760
-rw------- 1 celer-uat celer-uat 5242880 Sep 14 23:15 db_client_uat_core_server_log_v1_55040
-rw------- 1 celer-uat celer-uat 5242880 Sep 15 05:31 db_client_uat_core_server_log_v1_56320
-rw------- 1 celer-uat celer-uat 5242880 Sep 15 14:06 db_client_uat_core_server_log_v1_57600
-rw------- 1 celer-uat celer-uat 5242880 Sep 15 19:47 db_client_uat_core_server_log_v1_58880
-rw------- 1 celer-uat celer-uat 5242880 Sep 16 05:18 db_client_uat_core_server_log_v1_60160
-rw------- 1 celer-uat celer-uat 5242880 Sep 16 13:20 db_client_uat_core_server_log_v1_61440
-rw------- 1 celer-uat celer-uat 5242880 Sep 16 21:23 db_client_uat_core_server_log_v1_62720
-rw------- 1 celer-uat celer-uat 5242880 Aug 26 19:17 db_client_uat_core_server_log_v1_6400
-rw------- 1 celer-uat celer-uat 5242880 Sep 17 07:22 db_client_uat_core_server_log_v1_64000
-rw------- 1 celer-uat celer-uat 5242880 Sep 17 14:25 db_client_uat_core_server_log_v1_65280
-rw------- 1 celer-uat celer-uat 5242880 Sep 17 07:22 db_client_uat_core_server_log_v1_66560
-rw------- 1 celer-uat celer-uat 5242880 Aug 27 05:57 db_client_uat_core_server_log_v1_7680
-rw------- 1 celer-uat celer-uat 5242880 Aug 27 16:44 db_client_uat_core_server_log_v1_8960
data/snapshots
-rw------- 1 celer-uat celer-uat 6225993 Sep 10 02:59 db_client_uat_core_server_0_snapshot_v1_0_142695
-rw------- 1 celer-uat celer-uat 12435529 Sep 16 07:43 db_client_uat_core_server_0_snapshot_v1_0_255603
-rw------- 1 celer-uat celer-uat 9117769 Sep 14 17:07 db_client_uat_core_server_2_snapshot_v1_0_141524
-rw------- 1 celer-uat celer-uat 12279881 Sep 16 07:43 db_client_uat_core_server_2_snapshot_v1_0_180625
-rw------- 1 celer-uat celer-uat 9867337 Sep 15 07:47 db_client_uat_core_server_4_snapshot_v1_0_282746
-rw------- 1 celer-uat celer-uat 12480585 Sep 16 07:43 db_client_uat_core_server_4_snapshot_v1_0_316871
-rw------- 1 celer-uat celer-uat 9183305 Sep 14 17:03 db_client_uat_core_server_6_snapshot_v1_0_141458
-rw------- 1 celer-uat celer-uat 12324937 Sep 16 07:43 db_client_uat_core_server_6_snapshot_v1_0_184887
-rw------- 1 celer-uat celer-uat 479305 Sep 16 07:43 db_client_uat_core_server_snapshot_v1_0_61750
-rw------- 1 celer-uat celer-uat 467017 Aug 26 19:00 db_client_uat_core_server_snapshot_v1_0_7626
So this node has 4 partitions:
db_client_uat_core_server_0
db_client_uat_core_server_2
db_client_uat_core_server_4
db_client_uat_core_server_6
as well as the reference database:
db_client_uat_core_server
Each of these have their own log streams (_log_v1_XXXXX files), so they can each use up to 500 MB of disk for logs (roughly - the 500 MB limit is not a hard limit. That is when a snapshot will trigger asynchronously and old logs will get cleaned up so if there are concurrent writes you can still go over this limit). So for example db_client_uat_core_server_2 has 32 log files (using up 320 mb).
Everything here looks okay based on the settings your using above. Why you want to limit the server to such a small disk foot print?
-Adam
Thanks for the details. I just don’t like wasting. No matter what.
The contents of the DB are about 300MB worth so I was little surprised to see memsql needing 3GB of disk for it.