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: Also… what about storing images outside of the DB? ( 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. …

[图片] sam: Images are stored outside the DB already! Ah nice! [图片] sam: 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. Will that mean they get resiz…

[图片] 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.

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:

为什么每日备份的大小会减少？

产品支持

schungx (Stephen Chung) 2018 年8 月 6 日 01:27 7

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.

话题		回复	浏览量
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	3934	2016 年4 月 25 日
Backups are duplicating and not respecting number to keep on disk Self-hosting	67	3174	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	3031	2020 年7 月 23 日

为什么每日备份的大小会减少？

相关话题