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]> 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]. > 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]. For more options, visit https://groups.google.com/d/optout.
