The proposed settings from Kingsley and optimizing the sparql queries did
the trick.
All responses are handled in an acceptable time range.
What about the new version of virtuoso, will it be easy to update from an
existing version?
Here´s the output of SQL> status('');
OpenLink Virtuoso Server Version 06.01.3127-pthreads for Linux as of Feb
18 2011 Started on: 2011/03/23 14:44 GMT+60 Database Status: File
size 331350016, 40448 pages, 24515 free. 600000 buffers, 1268 used, 142
dirty 0 wired down, repl age 0 0 w. io 0 w/crsr. Disk Usage: 1171 reads
avg 0 msec, 0% r 0% w last 0 s, 157 writes, 31 read ahead, batch = 17.
Autocompact 11 in 8 out, 25% saved. Gate: 62 2nd in reads, 0 gate write
waits, 0 in while read 0 busy scrap. Log = virtuoso.trx, 4045 bytes 15729
pages have been changed since last backup (in checkpoint state) Current
backup timestamp: 0x0000-0x00-0x00 Last backup date: unknown Clients: 0
connects, max 0 concurrent RPC: 1 calls, 0 pending, 1 max until now, 0
queued, 0 burst reads (0%), 0 second brk=5064474624 Checkpoint Remap 38
pages, 0 mapped back. 0 s atomic time. DB master 40448 total 24515 free 38
remap 1 mapped back temp 256 total 251 free Lock Status: 0 deadlocks
of which 0 2r1w, 0 waits, Currently 1 threads running 0 threads waiting 0
threads in vdb. Pending:
Looks well I think?
Best,
Philipp
2011/3/23 Hugh Williams <[email protected]>
> Hi Philipp,
>
> On 23 Mar 2011, at 13:17, Kingsley Idehen wrote:
>
> On 3/23/11 8:29 AM, pfeucht84 wrote:
>
> Hi There,
>
> I´m going to use a virtuoso server as RDF-Triplestore for a pilot project
> with metadata.
> The store itself is going to hold about 550 triples at once, the workload
> of the server
> will not be enormous at peak times
>
>
> Do you mean 550 million triples?
>
>
> The server´s setup:
> - Virtual Machine with 2*2,4 GHZ and 8GB RAM
> - Virtuoso Open Source Edition v6
>
> During the project I´ve encountered some performance issues regarding the
> server.
>
>
> What are you INI file settings re. buffers ("NumberOfBuffers" in the Server
> section of INI).
>
> Recommended size for 8GB would between: 500,000 and 600,000.
>
>
> Could you please hint me in the right direction how to set up my virtuoso
> with the given
> environment? Any advice regarding the virtuoso.ini would be very helpful.
>
>
> Some performance tuning & diagnostic guides:
>
> 1. http://docs.openlinksw.com/virtuoso/perfdiag.html - diagnosing
> performance issue
> 2. http://docs.openlinksw.com/virtuoso/ptune.html - tuning guide
> 3. http://docs.openlinksw.com:80/virtuoso/dbadm.html#ini_Parameters -- INI
> guide .
>
>
> [Hugh] Note, if you have not seen it already, there is also the following
> document specifically on Virtuoso performance tuning for RDF use:
>
> http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html
>
> Also, what Virtuoso open source build are you using I presume the 6.12
> build on source forge which is from July 2010 ? There is a later 6.1.3 RC
> snaphot you would benefit from using, if you don't already have it, at:
>
>
> ftp://download.openlinksw.com/support/vos/virtuoso-opensource-6-20110308.tar.gz
>
> You can check the number of Buffers in use and how many are allocated by
> the server with the Virtuoso "status)('')" command :
>
> SQL> status(''); REPORT VARCHAR
> _______________________________________________________________________________
> OpenLink Virtuoso VDB Server Version 06.02.3129-pthreads for Mac OS X as of
> Mar 17 2011 Registered to Virtuoso Development - INTERNAL USE ONLY
> (Enterprise Edition, 500 connections) Started on: 2011/03/22 17:31 GMT+00
> Database Status: File size 497025024, 60672 pages, 40341 free. *4000
> buffers, 3733 used,* 0 dirty 0 wired down, repl age 7368 0 w. io 0 w/crsr.
> Disk Usage: 4195 reads avg 7 msec, 0% r 0% w last 0 s, 719 writes, 79 read
> ahead, batch = 7. Autocompact 0 in 0 out, 0% saved. Gate: 197 2nd in reads,
> 0 gate write waits, 0 in while read 0 busy scrap. Log = virtuoso.trx, 6357
> bytes VDB: 0 exec 0 fetch 0 transact 0 error 20290 pages have been changed
> since last backup (in checkpoint state) Current backup timestamp:
> 0x0000-0x00-0x00 Last backup date: unknown Clients: 2 connects, max 1
> concurrent RPC: 20 calls, 0 pending, 1 max until now, 0 queued, 0 burst
> reads (0%), 0 second brk=9 Checkpoint Remap 0 pages, 0 mapped back. 43 s
> atomic time. DB master 60672 total 40341 free 0 remap 0 mapped back temp 768
> total 763 free Lock Status: 0 deadlocks of which 0 2r1w, 0 waits, Currently
> 1 threads running 0 threads waiting 0 threads in vdb. Pending: 25 Rows. --
> 124 msec. SQL>
>
> I hope this helps ...
>
> Best Regards
> Hugh Williams
> OpenLink Software
>
>
>
> Kingsley
>
>
> Thank you in advance,
> Best,
> Philipp Feucht
>
>
>
> ------------------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
>
>
> _______________________________________________
> Virtuoso-devel mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>
>
>
> --
>
> Regards,
>
> Kingsley Idehen
> President & CEO
> OpenLink Software
> Web: http://www.openlinksw.com
> Weblog: http://www.openlinksw.com/blog/~kidehen
> Twitter/Identi.ca: kidehen
>
>
>
>
>
> ------------------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today!
> http://p.sf.net/sfu/intel-dev2devmar_______________________________________________
> Virtuoso-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>
>
>
>
> ------------------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
> _______________________________________________
> Virtuoso-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
>
>
