Hi Philipp, Good to hear your performance issue have been resolved.
To upgrade to the latest snapshot version, as the database is compatible between the two you can simply run checkpoint on the existing database to commit all pending transactions etc to the databases file, shutdown the database instance and copy the database file (virtuoso.db) over to the location of the new build and restart from this location. Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 23 Mar 2011, at 15:09, pfeucht84 wrote: > 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 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 > > > ------------------------------------------------------------------------------ > 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
