Hi, and thank you for the answers.
I will certainly try this. For some strange reason this database still consists of 36G worth of stb files. FYIþ I have not been able to replicate this behavior I will report my findings. Regards, -Stefan On Tuesday, 21 April 2015 08:44:06 UTC, l.garulli wrote: > > Hi guys, > We have a typo and we really call it "freee" with 3 e! Fixing it in > current SNAPSHOTS, so Stefan use "sbtreebonsai.freeeSpaceReuseTrigger", > but then remember to switch to: > > sbtreebonsai.freeSpaceReuseTrigger > > If you use 2.0.9-SNAPSHOT or 2.1-rc2 or later. > > Lvc@ > > > On 21 April 2015 at 08:42, Andrey Lomakin <[email protected] > <javascript:>> wrote: > >> Hi Stefan. >> About your question. >> *.sbc* files are used to store relations (edges) between vertexes. >> In sbc files space is occupied by removed edges reused only if it >> occupies half of total space to make possible to put all edges related to >> single vertex in close to each other on the disk. >> Could you set parameter sbtreebonsai.freeeSpaceReuseTrigger to 0 and >> check result ? >> >> On Fri, Apr 17, 2015 at 1:54 PM, <[email protected] <javascript:> >> > wrote: >> >>> Hi, >>> >>> This is looking more and more like a "corrupt" database even though it's >>> fully functional. >>> >>> I have not been able to replicate this behavior by importing the same >>> data again. >>> >>> I'm not as concerned now as I was but I would like to get a copy of it >>> to you for analysis. (if you like) >>> >>> I really have no idea what happened but this instance is radically >>> different from the other two that I have created using the same data. >>> >>> I would still like to know what the *.sbc* files are to try to >>> understand what went wrong with this instance. >>> >>> Regards, >>> -Stefan >>> >>> >>> On Friday, 17 April 2015 07:33:26 UTC, [email protected] wrote: >>>> >>>> >>>> Thank you Colin, I do appreciate that. >>>> >>>> On Friday, 17 April 2015 02:52:18 UTC, Colin wrote: >>>>> >>>>> Hi Stefán, >>>>> >>>>> I'm working on getting you answer. >>>>> >>>>> Best regards, >>>>> >>>>> -Colin >>>>> >>>>> Orient Technologies >>>>> >>>>> The Company behind OrientDB >>>>> >>>>> >>>>> On Thursday, April 16, 2015 at 5:04:41 PM UTC-5, >>>>> [email protected] wrote: >>>>>> >>>>>> >>>>>> No one? >>>>>> >>>>>> On Thursday, 16 April 2015 09:20:14 UTC, [email protected] >>>>>> wrote: >>>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I think this is quite a serious matter that demands attention from >>>>>>> those in-the-know. >>>>>>> >>>>>>> Can someone please share a light on what these *.sbc* files are and >>>>>>> what can be done to keep *.wal* and *.sbc* files in check. >>>>>>> >>>>>>> Regards, >>>>>>> -Stefán >>>>>>> >>>>>>> >>>>>>> On Wednesday, 15 April 2015 08:53:56 UTC, [email protected] >>>>>>> wrote: >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> Thank you for the links. >>>>>>>> >>>>>>>> I'm running a test now to see how these are accumulated and the >>>>>>>> .sbc and .wal files take up 2/3 of the total storage space (1/3 each). >>>>>>>> >>>>>>>> Viewing the content of the .sbc files reviles nothing as they seem >>>>>>>> to contain the same "garbage"-patter repeatedly. >>>>>>>> >>>>>>>> I'm quite concerned because this (alleged) storage inefficiency is >>>>>>>> affecting our plans. >>>>>>>> >>>>>>>> Can someone that knows please chime in? (I'm hoping this is a >>>>>>>> settings/configuration mistake on my behalf) >>>>>>>> >>>>>>>> Regards, >>>>>>>> -Stefán >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Tuesday, 14 April 2015 18:15:11 UTC, [email protected] wrote: >>>>>>>>> >>>>>>>>> This part of the docs detail what the various extensions mean, >>>>>>>>> however I do not see a ".sbc" >>>>>>>>> >>>>>>>>> http://orientdb.com/docs/last/orientdb.wiki/Paginated-Local-Storage.html >>>>>>>>> >>>>>>>>> >>>>>>>>> This part of the javadoc lists ".sbc" as the default extension for >>>>>>>>> >>>>>>>>> "com.orientechnologies.orient.core.db.record.ridbag.sbtree.OSBTreeCollectionManagerAbstract" >>>>>>>>> http://orientdb.com/javadoc/latest/constant-values.html >>>>>>>>> >>>>>>>>> I'm still not sure what ".sbc" means but it looks like it >>>>>>>>> represents some sort of index structure, hopefully those links are >>>>>>>>> helpful. >>>>>>>>> >>>>>>>>> On Tuesday, April 14, 2015 at 12:14:58 AM UTC-7, >>>>>>>>> [email protected] wrote: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> Can you at least tell me what these *.sbc* files are? >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> -Stefan >>>>>>>>>> >>>>>>>>>> On Monday, 13 April 2015 12:13:13 UTC, [email protected] >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> >>>>>>>>>>> I'm running Orientdb for a relatively "small" project and the >>>>>>>>>>> storage space taken by OrientDB puzzles me quite a bit. >>>>>>>>>>> >>>>>>>>>>> I have 12 million "empty (not light)" edges (12.271.168) taking >>>>>>>>>>> up *850mb* of storage space. >>>>>>>>>>> I also have *25G* worth of *.sbc* files even though the data >>>>>>>>>>> files are "only" about *1G.* >>>>>>>>>>> >>>>>>>>>>> Am I doing something obviously wrong or ? >>>>>>>>>>> >>>>>>>>>>> Regards, >>>>>>>>>>> -Stefán >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Best regards, >> Andrey Lomakin. >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB > http://about.me/luca.garulli > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
