Page 1 of 1

Size of library folder

PostPosted: Wed Jan 01, 2014 10:16 am
by ronnyvedal
Hello

A while ago i added a pictures-folder to my library. The folder had extremely lot of pictures and when it was done indexing the library folder was like 7 gigs.
This is a while ago and i removed this folder from the library a few days after i added it. I now notice that the library folder is still the same size.
Is this normal?

I also tested once, checking size of the library dir before and after renaming a bunch of files (1000+ files) in one of the shared folders. Everything looked OK on the clients with the new file-names but the libraryfolder just got even bigger.

I thought serviio automatically refreshed/reindexed the database to avoid using unnessecary diskspace for libraryfiles?

Re: Size of library folder

PostPosted: Wed Jan 01, 2014 11:37 am
by zip
Serviio will remove the items from the database, but it's possible the D engine does not do any further optimization (unless somehow forced?). Easiest might be to reinstall.

Re: Size of library folder

PostPosted: Wed Jan 01, 2014 4:47 pm
by ronnyvedal
Yea it removes it from the database, but the library-directory remains very huge.
Just thought i'd mention this, in case you didnt know it. If its possible to solve this without a reinstall it would be great.
Since it takes a long time to add everything again, i really dont want to reinstall unless its needed.

Re: Size of library folder

PostPosted: Wed Jan 01, 2014 6:48 pm
by ronnyvedal
Is there a way to "save" settings like presentation-settings so i can just load it again after a reinstall? I have this very customized and its a pain in the ass to reconfigure everything.

Re: Size of library folder

PostPosted: Wed Jan 01, 2014 7:30 pm
by will
Does Derby not have a vacuum procedure that you can call?

Re: Size of library folder

PostPosted: Thu Jan 02, 2014 6:58 pm
by bolzass
will wrote:Does Derby not have a vacuum procedure that you can call?


I had the same problem and made that for me (linux):
Reading the apache derby doc, I found the SYSCS_UTIL.SYSCS_COMPRESS_TABLE call, so I made the "vacuum" script (I'm not a DBA :? .

If you want to use that;
- Stop serviio (needed to run it & safe backup)
- first make a BACKUP
- extract files and edit vacuum to adapt "SERVIIO_HOME, SERVIIO_LIBRARY and SERVIIO_LIB" vars (first lines)
- and the run vacuum as your serviio user (not root) because it will create new files!.
- Wait for a while! (7 gigs will take some minutes / quarter....)

Hope this help.

Note: Because of file size limits, I emptied "derby.jar" at lib sub-directory. Copy it from your serviio installation or set SERVIIO_LIB accordingly.

PS: Also interested on saving preferences!;)