Not logged in : Login

About: VirtTipsAndTricksGuideTransactionLogControl     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • VirtTipsAndTricksGuideTransactionLogControl
maker
Title
  • VirtTipsAndTricksGuideTransactionLogControl
isDescribedUsing
has creator
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]]
id
  • b3651ef6c3e22336a416cd261318e5b1
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • VirtTipsAndTricksGuideTransactionLogControl
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:47:39Z
atom:updated
  • 2017-06-13T05:47:39Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git132 as of May 12 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 07.20.3238 as of May 23 2023, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 3 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software