Hi Hugh,

> virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.3-pre1.3127-pthreads as of Sep 23 2010
Compiled for Linux (x86_64-unknown-linux-gnu)

Cheers,
Martin

On 24.01.2012 02:16, Hugh Williams wrote:
Hi Martin,

Assuming an average triple size of 30 bytes, 150 million triples would require 4.5GB of memory ie 562500 (4.5GB / 8K) NumberOfBuffers. Although also how many triples are there in the Virtuoso Quad stores as that would determine the size required for hosting to the database working set in memory.

What is the Virtuoso version being used, which can be determined by running the command:

virtuoso-t -?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 23 Jan 2012, at 13:59, Martin Gerlach wrote:

Hi Hugh,

I tried as described on the Web page. For a while, memory usage remained constant, but after a while it suddenly rose and broke:

14:55:30 ERROR: Memory low! Using memory reserve to terminate current activities properly
14:55:30 ERROR: Current location of the program break 13070086144
14:55:30 ERROR: GPF: gate.c:1464 loop in registered cursors

Any recommendation on the NumberOfBuffers settings for that operation?

Cheers,
Martin

On 23.01.2012 12:43, Hugh Williams wrote:
Hi Martin,

Please see the following tip on rename graphs in Virtuoso, the key for large graphs being to perform the operation in auto-commit mode (log_enable(3)) to avoid excessively sized transaction log depleting memory:

http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 23 Jan 2012, at 10:49, Martin Gerlach wrote:

Hi,

I'd like to rename a graph with about 150 million triples in Virtuoso
Open Source 6.1

The Virtuoso db file has 16GB.

Which is the best way to rename such a big graph? Going through
Conductor/RDF/Graphs/rename or using isql?

Which are the required buffer sizes for renaming the graph?

I tried with 2,3 Mio max buffers and max dirty buffers (18 GB which is
75% of the machine's RAM), but Virtuoso crashed after this log output:

11:37:36 ERROR: Memory low! Using memory reserve to terminate current
activities properly
11:37:36 ERROR: Current location of the program break 19991629824
11:37:36 ERROR: GPF: gate.c:1464 loop in registered cursors

Cheers,
Martin



------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Virtuoso-users mailing list
[email protected] <mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--

*Martin Gerlach*
Senior Softwareentwickler
Research

Neofonie GmbH
Robert-Koch-Platz 4
10115 Berlin

T +49.30 24627 *413*
F +49.30 24627 120
[email protected] <mailto:[email protected]>
http://www.neofonie.de <http://www.neofonie.de/>

Handelsregister
Berlin-Charlottenburg: HRB 67460

Geschäftsführung
Thomas Kitlitschko
Dr. Mario Lenz

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
------------------------------------------------------------------------

*Martin Gerlach*
Senior Softwareentwickler
Research

Neofonie GmbH
Robert-Koch-Platz 4
10115 Berlin

T +49.30 24627 *413*
F +49.30 24627 120
[email protected]
http://www.neofonie.de

Handelsregister
Berlin-Charlottenburg: HRB 67460

Geschäftsführung
Thomas Kitlitschko
Dr. Mario Lenz

Reply via email to