Hi All,
I am trying to performance tune VOS 7.1.1 which i got from git and i have few
questions about some of the parameters in virtuoso.ini file
First some instruction about my server setup. I have VOS 7.1.1 with 100GB
memory and around 1.4B triples. I have kept following values for buffer:
N
Thanks Kingsley and entire community for this meaning full discussion,
After this discussion, I have 2 follow-up question.
1. How do I create a new empty database in my existing virtuoso and start
loading RDF data into that by default. I think this way I will be using
column-wise structure.
2.
e virtuoso : I recompile it from source
and then used my older ini file as i have made some performance tuning it that.
--sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Tuesday, May 20, 2014 3:03 PM
To: Purohit, Sumit
Cc: Bart Vandewoestyne; virt
I +1 Bart's question as I also want to know which tables are using latest
column store.
Is there a way ?
Thanks
Sumit Purohit
-Original Message-
From: Bart Vandewoestyne [mailto:bart.vandewoest...@telenet.be]
Sent: Tuesday, May 20, 2014 4:50 AM
To: virtuoso-users@lists.sourceforge.ne
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Saturday, May 17, 2014 5:46 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Using column store structure for exiting data
Hi Sumit,
By default all SQL tables would be created as
.0.1
Transaction status: PENDING, 1 threads.
Locks:
Running Statements:
Time (msec) Text
387 status()
Hash indexes
37 Rows. -- 388 msec.
thanks
sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Saturday, May 17, 2014 5:36 PM
To: Purohit, S
Hi All,
I am using Virtuoso (Open Source) 7.1.0 and read about support of column-store
structure in virtuoso.
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html
Does setting ColumnStore=1 affect only tables created after the change OR DOES
IT RE-INDEX / RE-STRUCTURE exiting tables and ind
Hi,
I have observed many times after loading rdf data into a named graph using
ld_dir() or ld_dir_all(), updated list of graph does show up either on
conductor->linked data-> Graphs or using query like
SELECT DISTINCT ?g
WHERE {
GRAPH ?g {
?s ?p ?o
}
}
Behavior is quite random and som
anks
sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Thursday, May 08, 2014 3:58 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0
Hi Sumit,
You simply run the "checkpoint"
From: Purohit, Sumit
Sent: Thursday, May 08, 2014 2:00 PM
To: Hugh Williams
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0
thanks for prompt response.
Can you explain what you mean by "nsuring a checkpoint has been performed such
that the
ay, May 08, 2014 2:18 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0
Hi Summit,
There are no instructions necessary, as the databases between the two versions
are compatible. So you simply shutdown the 7.0 databas
Hi,
I want to update virtuoso (open source) from 7.00.3203 to latest version 7.1.0.
I could not find any update instructions for this version. Included
README.UPDATE talks about "Upgrading from VOS 6.1.X to VOS 6.1.4" as latest.
Is there any documentation to upgrade to v7.1.0 ?
2nd question i h
"log_enable(3,1);" mentioned in 2nd link did the trick. I am able to delete
large graph without any issue.
Thank you .
--sumit purohit
From: Hugh Williams [mailto:hwilli...@openlinksw.com]
Sent: Saturday, April 05, 2014 2:44 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourc
Hi All,
I have a virtuoso (open source Version: 07.00.3203 Build: Aug 5 2013) server
with around 1.4 B triples.
Recently i tried to delete a named graph which has 285566 triples but on all 3
attempts virtuoso crashed after few minuets.
I used following command on isql prompt to delete the graph
Hi Dimitris,
I recently used following procedure(s) to dump rdf graph into ttl files.
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump
and these worked perfectly . I am not sure about validity of the link you
provided but you can try above link.
Hope this helps.
Tha
Hi All,
I am trying to dump my existing virutoso graphs into .ttl file.
I refer
http://www.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump#Dump%20One%20Graph
but when i run in on my SQL console, i get
SQL>
dump_one_graph('','/data1/virtuosodumpDec18/_',10)
;
*** Error 4
Hi All,
I bulk loaded 11M rdf file (.ttl) into virtuoso graph "A" using "ld_dir" and
"rdf_loader_run" and it took 8.5 hours which seems a lot slower considering
virtuoso can load data at 36K per second on a single 4 core machine as per
virtuoso documentation. ( http://goo.gl/D5zw1)
Considering
send dump of "ps -ef" in previous reply , please see that to confirm if there
is any nsflock daemon. i see "nfsoid" and "locked" process.
thanks for your help
sumit
From: Patrick van Kleef [pkl...@openlinksw.com]
Sent: Monday,
/conf/logging.properties
-
root 3877 2039 5 09:17 pts/100:00:00 ps -ef
[root@rdesc db]#
Thanks
sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Monday, March 25, 2013 1:36 AM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
__
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Sunday, March 24, 2013 6:39 PM
To: Purohit, Sumit
Cc: Kingsley Idehen; virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to
localhost:
Hi Sumit,
Please provide the com
_
From: Kingsley Idehen [kide...@openlinksw.com]
Sent: Sunday, March 24, 2013 9:25 AM
To: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to
localhost:
On 3/23/13 10:28 PM, Purohit, Sumit wrote:
> root 2936 2039 0 19:2
root 2936 2039 0 19:28 pts/100:00:00 grep virtuoso
can i kill it ??? i wanna kill it :-)
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Saturday, March 23, 2013 6:17 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject
opensource/var/lib/virtuoso/db
[root@rdesc db]#
How does virtuoso-t determine that an instance is already running
thanks
sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Saturday, March 23, 2013 3:29 PM
To: Purohit, Sumit
Cc: virtuoso-users
umit
From: Hugh Williams [mailto:hwilli...@openlinksw.com]
Sent: Saturday, March 23, 2013 2:58 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to
localhost:
Hi Sumit,
Why is there a file called "virtuoso.ini
...@openlinksw.com]
Sent: Friday, March 22, 2013 8:25 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] Unable to connect to virtuoso : Connect failed to
localhost:
Hi Sumit,
You removed the "virtuoso.lck" and restarted Virtuoso how, by manually
Hi All,
I have a virtuoso installed on my VM and i had to reboot it for some reason.
But once i reboot it, i am not bole to connect to Virtuoso.
when i restart it my log says :
Fri Mar 22 2013
18:14:33 { Loading plugin 1: Type `plain', file `wikiv' in
`/usr/local/virtuoso-opensour
Hi Uldis,
I did same configuration changes in RedHat and it was only changing
virtuoso.ini file and restarting the server. I changed following entries
[Database]
DatabaseFile= /virtuoso.db
ErrorLogFile= /virtuoso.log
LockFile= /virt
Thanks Hugh for pointing me to correct location. Will give it a try.
--sumit
From: Hugh Williams [hwilli...@openlinksw.com]
Sent: Thursday, March 21, 2013 7:33 PM
To: Purohit, Sumit
Cc: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users
Hi All,
I have setup a Virtuoso server and i need it to tune its triple store for large
amount of rdf data.
with default configuration one of my dataset took 4 days to load :-) ..i have a
8 core 16GB machine.
IS this the right and complete page to follow in order to tune it for higher
performa
Hi All,
I am a new virtuoso user and have installed open source version 6.4.
I plan to import huge amount of rdf data into it (order of million triples ).
I want virtuoso to point to an external mounted disk to use as content store/db
store.
What do i need to configure in order to do that ?
If
Hi All,
I have started exploring virtuoso to use it for geo spatial query. One of my
requirement is to support different geometries from POINT to Rectangle and
polygon, circle
After searching mailing list I found some discussions about this.
https://sourceforge.net/mailarchive/message.php?msg_i
31 matches
Mail list logo