cofluence file storage

[Александр Гаврилюк]

How can I configure the storage of files from the application confluence on the server in a separate folder?
Necessary in order not to overload the database SQL SERVER
Has anyone set up a confluence like this?

[Sid]

Confluence in the latest version stores on in the home directory you specified as @Nic Brough -Adaptavist- mentioned. 

You can find the exact location in system information 

[Nic Brough -Adaptavist-]

Ok, I'm not sure why you started looking at the database if you've installed a recent version of Confluence, as all the guides tell you to make sure you have enough disk space for attachments in the <confluence home> area.

Confluence is not a file server, it is a wiki.  The files are stored in a way that is designed for Confluence usage.  Technically, yes, there's a url for every file, but you need to have read access via confluence to get to each one.

[Александр Гаврилюк]

Thank tou for the information!

[Sid]

hi @Александр Гаврилюк,

From the KB, if you are looking for the migration options please look into this - https://confluence.atlassian.com/doc/attachment-storage-configuration-166876.html

[Александр Гаврилюк]

I installed a new version of confluence and wanted to make sure of where confluence stores files.
In order to make sure that confluence does not destroy all the RAM.
as I understand it, confluence stores files on the hard disk. Are the files in the application available as links to this disk?

[Nic Brough -Adaptavist-]

Ok, I'm not sure I understand what you're getting at.

Mostly, Confluence does not "load the database" with attachments, because the files are all stored in the attachments directory.

There are some old versions that allowed you to store the files in the database, but that is no longer supported or done.

So, my guess is that you have built or inherited an old system that has the attachments in the database, and you want to move them out?  Is that right?

[Александр Гаврилюк]

Thank you for the detailed explanation. But I still did not understand how to configure the confluence so as not to overload the MS SQL database.
That is, all attachments are stored in the "Attachments" folder and do not load the database?
I apologize if I ask banal things. I work with confluence for the first month.

[Nic Brough -Adaptavist-]

Probably most of us. 

Confluence went through a phase of allowing us to put the attachments in the database, but the return on investment on that was very low, causing just as many problems as it solved, and then rapidly became redundant and then  incompatible with newer technologies. 

So, I would guess that 99.9% of Confluence installations have their attachments on a disk, not in a database nowadays. 

All of them past version 4 will have the attachments stored at <confluence home>/attachments and that can't be changed in the UI.  But a lot of those directories will be remotely mounted shared file systems, or symbolic links to shared storage, or, or, or.

Confluence does not really care what the underlying tech is, as long as it can put its attachments into a file tree under <confluence home>/attachments.