From: Bryan T. <br...@sy...> - 2015-04-23 18:57:46
|
I will say that I am observing a lot of IO Wait on that data set, even on an SSD (~10-20%). I am using just the out of the box settings for a newly created kb. These are by no means optimal. I would suggest a larger pool of write cache buffers in order to reduce the disk IO. The write cache buffers make it possible for index pages that are evicted and then modified before they are actually written to the disk to skip the IO for the first modified version of the page. This can be quite a substantial savings for large data set loads. Bryan ---- Bryan Thompson Chief Scientist & Founder SYSTAP, LLC 4501 Tower Road Greensboro, NC 27410 br...@sy... http://blazegraph.com http://blog.bigdata.com <http://bigdata.com> http://mapgraph.io Blazegraph™ <http://www.blazegraph.com/> is our ultra high-performance graph database that supports both RDF/SPARQL and Tinkerpop/Blueprints APIs. MapGraph™ <http://www.systap.com/mapgraph> is our disruptive new technology to use GPUs to accelerate data-parallel graph analytics. CONFIDENTIALITY NOTICE: This email and its contents and attachments are for the sole use of the intended recipient(s) and are confidential or proprietary to SYSTAP. Any unauthorized review, use, disclosure, dissemination or copying of this email or its contents or attachments is prohibited. If you have received this communication in error, please notify the sender by reply email and permanently delete all copies of the email and its contents and attachments. On Thu, Apr 23, 2015 at 9:30 AM, Andreas Kahl <ka...@bs...> wrote: > Now I am 25mins into the new load with groupCommit enabled and > com.bigdata.rwstore.RWStore.smallSlotType=1024 commented out. > Currently 24,870,000 Triples are parsed and the journal is at 3.6GB. It > looks like disabling smallSlotOptimization also resolves the problem > (Otherwise I would have more than twice the space used at that time). > > So, I would conclude, it's the combination of groupCommit and > smallSlotOptimization. > > All tests were run on Blazegraph 1.5.1 from Git revision f4c63e5. > > Best Regards > Andreas > > > >>> "Andreas Kahl" <ka...@bs...> 23.04.2015 14:54 >>> > Bryan, > > in the meantime, I could successfully load the file into a 18GB journal > after disabling groupCommit (I simply commented out the line in > RWStore.properties). > I can try again with groupCommit enabled, but smallSlotOptimization > disabled. > > Best Regards > Andreas > > >>> Bryan Thompson <br...@sy...> 23.04.2015 13:24 >>> > Andreas, > > I was not able to replicate your result. Unfortunately I navigated away > from the browser page in which I had submitted the request, so it loaded > all the data but failed to commit. However, the resulting file is only > 16GB. > > I will redo this run and verify that the journal after the commit has this > same size on the disk. > > I was only assuming that this was related to group commit because of your > original message. Perhaps I misinterpreted your message. This is simply > about 1.5.1 (with group commit) vs 1.4.0. > > Perhaps the issue is related to the small slot optimization? Maybe in > combination with group commit? > > *> com.bigdata.rwstore.RWStore.smallSlotType=1024* > > I could not replicate your properties exactly because you are using a > non-standard vocabulary class. Therefore I simply deleted the default > namespace (in quads mode) and recreated it with the defaults in triples > mode. The small slot optimization and other parameters were not enabled in > my run. > > Perhaps you could try to replicate my experience and I will enable the > small slots optimization? > > Thanks, > Bryan > > ---- > Bryan Thompson > Chief Scientist & Founder > SYSTAP, LLC > 4501 Tower Road > Greensboro, NC 27410 > br...@sy... > http://blazegraph.com > http://blog.bigdata.com <http://bigdata.com> > http://mapgraph.io > > Blazegraph™ <http://www.blazegraph.com/> is our ultra high-performance > graph database that supports both RDF/SPARQL and Tinkerpop/Blueprints > APIs. MapGraph™ <http://www.systap.com/mapgraph> is our disruptive new > technology to use GPUs to accelerate data-parallel graph analytics. > > CONFIDENTIALITY NOTICE: This email and its contents and attachments are > for the sole use of the intended recipient(s) and are confidential or > proprietary to SYSTAP. Any unauthorized review, use, disclosure, > dissemination or copying of this email or its contents or attachments is > prohibited. If you have received this communication in error, please notify > the sender by reply email and permanently delete all copies of the email > and its contents and attachments. > > On Thu, Apr 23, 2015 at 1:51 AM, Andreas Kahl <ka...@bs...> > wrote: > > > Bryan & Martyn, > > > > Thank you very much for investigating the issue. I assume from the > ticket > > that the error will vanish if I disable groupCommit. I will do so for the > > meantime. > > > > Although there is already extensive information in Bryan's ticket, please > > find attached my logs and DumpJournal outputs: > > - dumpJournal.html contains a dump from the 67GB journal after Blazegraph > > ran into "No space left on device" > > - dumpJournalWithTraceEnabled.html is the same dump for a running query > > when the journal was at about 14GB > > - queryStatus.html is just the status page showing my query > > - catalina.out.gz contains the trace outputs from starting Tomcat until I > > killed the curl running the SPARQL Update by Ctrl-C > > - loadGnd.log.gz is Blazegraphs output when loading the data > > > > Best Regards > > Andreas > > > > > > > > >>> Bryan Thompson <br...@sy...> 22.04.15 20.56 Uhr >>> > > See http://trac.bigdata.com/ticket/1206. This is still in the > > investigation stage. > > > > Thanks, > > Bryan > > > > ---- > > Bryan Thompson > > Chief Scientist & Founder > > SYSTAP, LLC > > 4501 Tower Road > > Greensboro, NC 27410 > > br...@sy... > > http://blazegraph.com > > http://blog.bigdata.com <http://bigdata.com> > > http://mapgraph.io > > > > Blazegraph™ <http://www.blazegraph.com/> is our ultra high-performance > > graph database that supports both RDF/SPARQL and Tinkerpop/Blueprints > > APIs. MapGraph™ <http://www.systap.com/mapgraph> is our disruptive new > > technology to use GPUs to accelerate data-parallel graph analytics. > > > > CONFIDENTIALITY NOTICE: This email and its contents and attachments are > > for the sole use of the intended recipient(s) and are confidential or > > proprietary to SYSTAP. Any unauthorized review, use, disclosure, > > dissemination or copying of this email or its contents or attachments is > > prohibited. If you have received this communication in error, please > notify > > the sender by reply email and permanently delete all copies of the email > > and its contents and attachments. > > > > On Wed, Apr 22, 2015 at 5:37 AM, Andreas Kahl <ka...@bs...> > > wrote: > > > > > Hello everyone, > > > > > > I currently updated to the current Revision (f4c63e5) of Blazegraph > from > > > Git and tried to load a dataset into the updated Webapp. With Bigdata > > 1.4.0 > > > this resulted in a journal of ~18GB. Now the process was cancelled > > because > > > the disk was full - the journal was beyond 50GB for the same file with > > the > > > same settings. > > > The only exception was that I activated GroupCommit. > > > > > > The dataset can be downloaded here: > > > > > > http://datendienst.dnb.de/cgi-bin/mabit.pl?cmd=fetch&userID=opendata&pass=opendata&mabheft=GND.rdf.gz > > > . > > > Please find the settings used to load the file below. > > > > > > Do I have a misconfiguration, or is there a bug eating all disk memory? > > > > > > Best regards > > > Andreas > > > > > > Namespace-Properties: > > > curl -H "Accept: text/plain" > > > http://localhost:8080/bigdata/namespace/gnd/properties > > > #Wed Apr 22 11:35:31 CEST 2015 > > > > com.bigdata.namespace.kb.spo.com.bigdata.btree.BTree.branchingFactor=700 > > > com.bigdata.relation.container=gnd > > > com.bigdata.rwstore.RWStore.smallSlotType=1024 > > > com.bigdata.journal.AbstractJournal.bufferMode=DiskRW > > > com.bigdata.journal.AbstractJournal.file=/var/lib/bigdata/bigdata.jnl > > > > > > > > > com.bigdata.rdf.store.AbstractTripleStore.vocabularyClass=de.bsb_muenchen.bigdata.vocab.B3KatVocabulary > > > com.bigdata.journal.AbstractJournal.initialExtent=209715200 > > > com.bigdata.rdf.store.AbstractTripleStore.textIndex=true > > > com.bigdata.btree.BTree.branchingFactor=700 > > > > > > > > > com.bigdata.rdf.store.AbstractTripleStore.axiomsClass=com.bigdata.rdf.axioms.NoAxioms > > > com.bigdata.rdf.sail.isolatableIndices=false > > > com.bigdata.service.AbstractTransactionService.minReleaseAge=1 > > > com.bigdata.rdf.sail.bufferCapacity=2000 > > > com.bigdata.rdf.sail.truthMaintenance=false > > > com.bigdata.rdf.sail.namespace=gnd > > > com.bigdata.relation.class=com.bigdata.rdf.store.LocalTripleStore > > > com.bigdata.rdf.store.AbstractTripleStore.quads=false > > > com.bigdata.journal.AbstractJournal.writeCacheBufferCount=500 > > > com.bigdata.search.FullTextIndex.fieldsEnabled=false > > > com.bigdata.relation.namespace=gndity=10000 > > > com.bigdata.rdf.sail.BigdataSail.bufferCapacity=2000 > > > com.bigdata.rdf.store.AbstractTripleStore.statementIdentifiers=false > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT > > > Develop your own process in accordance with the BPMN 2 standard > > > Learn Process modeling best practices with Bonita BPM through live > > > exercises > > > http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- > > > event?utm_ > > > source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF > > > _______________________________________________ > > > Bigdata-developers mailing list > > > Big...@li... > > > https://lists.sourceforge.net/lists/listinfo/bigdata-developers > > > > > > > > > > > > > ------------------------------------------------------------------------------ > BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT > Develop your own process in accordance with the BPMN 2 standard > Learn Process modeling best practices with Bonita BPM through live > exercises > http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- > event?utm_ > source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF > _______________________________________________ > Bigdata-developers mailing list > Big...@li... > https://lists.sourceforge.net/lists/listinfo/bigdata-developers > |