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 list
>> [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
