The CPU utilization for the virtuoso-t process dropped back down once I
returned after a while. As a quick experiment, I ran the SPARQL query:
select distinct ?g where {graph ?g {?s ?p ?o}}
which drove virtuoso-t to 100% utilization which then timed out
returning the CPU back to baseline. Trying to list the graphs in
Conductor-->Linked Data-->Graphs which seems to be the same thing
(listing all of the named graphs) but "hangs" conductor much longer.
Perhaps, there is no timeout on this mechanism on this conductor
mechanism. Like before, shutting down virtuoso and then restarting,
both the conductor listing of graphs and the above SPARQL query execute
in approximately 1 second for the 120,000,000 triples and successfully
list the 4 named graphs in the system which is the response time that I
typically get with Virtuoso, but not until after the restart. - Erich
Erich Bremer
http://www.ebremer.com
http://haylyn.io
On 9/22/2013 8:32 AM, Hugh Williams wrote:
Hi Erich,
Is this condition reproducible as a restart of the server seems to
have resolved it ? As it would be interesting to see what the
"status();" command reports as to the status of the Virtuoso server
when in this state ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
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 22 Sep 2013, at 05:32, Erich Bremer <er...@ebremer.com
<mailto:er...@ebremer.com>> wrote:
Hi all,
I'm working with Virtuoso 7.0.0 open source edition and did a load of
geonames data using isql which was 123,020,822 triples into a named
graph "http://www.geonames.org";.
I did a second load of 13,349,346 triples into a different named graph.
Both loads of turtle RDF completed quickly. When I went to check to see
if Conductor could see the named graphs, Conductor hung when I clicked
on Linked Data-->Graphs. I then tried to do:
a) select distinct ?g where {graph ?g {?s ?p ?o}}
from the SPARQL endpoint and it timed out.
however, the following query against http://www.geonames.org would work
in a second:
b) select count(*) as ?cc where {?s ?p ?o}
I initiated a shutdown using isql which took a few moments and then I
restarted virtuoso. Now, Conductor quickly shows all named graphs
including the new ones, and the above SPARQL query (a) runs nearly
instantly.
- Erich
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
