Not logged in : Login
(Sponging disallowed)

About: VirtTipsAndTricksGuideTransactionLogControl     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=http%3A%2F%2Fwww.openlinksw.com%2Fdataspace%2Fdav%2Fwiki%2FMain%2FVirtTipsAndTricksGuideTransactionLogControl

AttributesValues
has container
Date Created
maker
topic
described by
seeAlso
Date Modified
link
id
  • c98b160512e706522cbb426fe7295d41
content
  • %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+ How can I perform SPARQL Updates without exceeding transactional log size? SPARUL updates are generally not meant to be transactional. To prevent running out of rollback space, it is usually best to tell Virtuoso to commit each operation as it is done, with this SQL call: <verbatim> SQL> log_enable (2); </verbatim> Transaction logging can also be turned off for [[VirtBulkRDFLoader][bulk updates]]. In such case, one should do a manual checkpoint after the bulk insert operation, to ensure persistence across server restart, since there will be no roll forward log. If you're only occasionally exceeding the configured transactional log size, you may prefer to set the "<b>TransactionAfterImageLimit</b>" parameter in the virtuoso.ini config file to a higher value than its 50MB default: <verbatim> #virtuoso.ini ... [Parameters] ... TransactionAfterImageLimit = 99999999 ; bytes default 50000000 ... </verbatim> ---++ Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul][Using SPARUL]] * [[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_Parameters][Virtuoso INI Parameters]]
Title
  • VirtTipsAndTricksGuideTransactionLogControl
has creator
is described using
atom:source
atom:updated
  • 2013-09-17T14:10:53Z
atom:title
  • VirtTipsAndTricksGuideTransactionLogControl
links to
atom:author
label
  • VirtTipsAndTricksGuideTransactionLogControl
topic
atom:published
  • 2011-02-28T05:58:22Z
type
is topic of
is interest of
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 26 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software