Last few days have been 3.4GB and today’s backup is reporting 3.3GB - is this normal or does it sound like something’s up? I don’t recall any large (or image) threads being deleted..

Yes, this is very normal. Recently @tgxworld did a massive data refactor that removed a large amount of bloat around the email logs table. This data saving is expected. One interesting thing though is how image heavy your forum is (cause if it was not the savings would have been even more noticeab…

Thanks Sam. I keep meaning to ask about images - is there anyway we can set Discourse to resize images to something like 1024px wide? Also… what about storing images outside of the DB? (Though would we need to use something like Rsync of backups?) I remember there was some discussion around these…

[画像] AstonJ: Will that mean they get resized automatically, or will users be told the images are too big and they need to resize themselves first? Try it out, we attempt to downsize on upload automatically to match the megapixel value you are allowing.

The images are resized for display but the original is always stored for retrieval, so it is not going to help your storage. Your best solution is to store the images in an online bulk storage like S3.

Automatic downsizing of originals AND history is definitely an opt-in feature we want to fully support.

What do you mean? Set a max image size in your site settings and that is indeed the max image size.

That’s true. That setting will prevent a large image from being uploaded at all. However, I think @AstonJ may be asking that if there is a feature in the system to: Accept an image upload from the user (up to some reasonable upper limit of course) Auto-resize that image to some max size (e.g. 10…

That’s already the case.. if you specify a max allowed, the images can’t be larger than that. I think it is in megapixels, so it’s about dimensions rather than absolute filesize, but the effect is the same. Rule 3 is met. There’s only so big a 128 x 128 image file can be, in bytes :wink:

日次バックアップのサイズが減少する理由はあるでしょうか？

製品サポート

sam (Sam Saffron) 2018 年 8 月 6 日午前 12:53 4

Images are stored outside the DB already!

Going forward you can lower max image size and megapixels on your forum to avoid the large images. But fixing the history here… I am not sure if we have a rake task for that quite yet.

トピック		返信	表示
Would it be worth resizing uploaded images (to save space)? Feature	26	5299	2019 年 10 月 11 日
How big is your Discourse backup? Product Support	15	3935	2016 年 4 月 25 日
Backups are duplicating and not respecting number to keep on disk Self-hosting	67	3179	2019 年 2 月 14 日
Recommended backup process for very large forum? Product Support	6	1457	2017 年 7 月 11 日
Disk usage spike during backup, Discourse crashed hard :-( Self-hosting server-resources	21	3033	2020 年 7 月 23 日

日次バックアップのサイズが減少する理由はあるでしょうか？

関連トピック