This HTML5 document contains 34 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
dctermshttp://purl.org/dc/terms/
n9http://vos.openlinksw.com/wiki/main/VOS/VirtTipsAndTricksGuideLDMeterUtility/ldmeter.
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n11http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
n19http://www.openlinksw.com/dataspace/dav/wiki/Main/
dchttp://purl.org/dc/elements/1.1/
n15http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n12http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n20http://www.openlinksw.com/weblog/oerling/?id=
n8http://vos.openlinksw.com/dataspace/person/dav#
n22http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtTipsAndTricksGuideLDMeterUtility/sioc.
n7http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n5http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n4http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/VOS/
n18http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
Subject Item
n8:this
foaf:made
n2:VirtTipsAndTricksGuideLDMeterUtility
Subject Item
n15:this
sioc:creator_of
n2:VirtTipsAndTricksGuideLDMeterUtility
Subject Item
n11:item
n12:services_of
n2:VirtTipsAndTricksGuideLDMeterUtility
Subject Item
n5:this
sioc:creator_of
n2:VirtTipsAndTricksGuideLDMeterUtility
Subject Item
n7:VOS
sioc:container_of
n2:VirtTipsAndTricksGuideLDMeterUtility
atom:entry
n2:VirtTipsAndTricksGuideLDMeterUtility
atom:contains
n2:VirtTipsAndTricksGuideLDMeterUtility
Subject Item
n2:VirtTipsAndTricksGuideLDMeterUtility
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:38:22.850367
dcterms:modified
2017-06-13T05:38:22.850367
rdfs:label
VirtTipsAndTricksGuideLDMeterUtility
foaf:maker
n8:this n18:this
dc:title
VirtTipsAndTricksGuideLDMeterUtility
opl:isDescribedUsing
n22:rdf
sioc:has_creator
n15:this n5:this
sioc:attachment
n9:sql
sioc:content
%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+LD Meter Utility Usage Guide %TOC% ---++What? The meter is a stored procedure that records the CPU time, count of reads, cumulative elapsed time spent waiting for I/O, and other metrics. The code for this procedure (for 7 Single; this file will not work on Virtuoso 6 or earlier). ---++Why? While we may know principles, I/O has always given us surprises; the only way to optimize this is to measure. ---++How? To use the LD Meter Utility: 1 Load the <a href="%ATTACHURLPATH%/ldmeter.sql" style="wikiautogen">ldmeter.sql</a> script into your Virtuoso instance; 1 Run <code><nowiki>ld_meter_run(N)</nowiki></code> to set the time interval in seconds in which the meter should be run which gets written to the <code><nowiki>ld_metric</nowiki></code> table which will contain data for the form: <verbatim> SQL> SELECT TOP 5 * FROM ld_metric; lm_id lm_dt lm_first_id lm_secs_since_start lm_n_rows lm_cpu lm_n_reads lm_read_time lm_read_pct lm_rows_per_s lm_cpu_pct lm_rusage INTEGER NOT NULL TIMESTAMP INTEGER INTEGER INTEGER INTEGER INTEGER INTEGER DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION VARCHAR _______________________________________________________________________________ 0 2012.5.12 18:8.58 0 0 0 4521388 990868 NULL 262 NULL NULL NULL vector(0x01431658,0x01431678,0x01431698,0x014316b8,0,0,168,5416,0x014316d8,0x014316f8) 1 2012.5.12 18:9.28 0 0 30 5070755 1109729 NULL 262 0 18311.6229459018 396.1867937735409 vector(0x01437a78,0x01437a98,0x01437ab8,0x01437ad8,0,0,168,5416,0x01437af8,0x01437b18) 2 2012.5.12 18:9.58 0 0 60 5599501 1228805 NULL 262 0 17624.27919069364 396.8867704409853 vector(0x014315f8,0x014315d8,0x014315b8,0x01431518,0,0,200,5416,0x01428fc8,0x01437898) 3 2012.5.12 18:10.28 0 0 90 6143726 1347315 NULL 262 0 18140.2286590447 395.0201659944669 vector(0x014379b8,0x01437998,0x01437978,0x01437958,0,0,6856,5416,0x01437938,0x014316f8) 4 2012.5.12 18:10.58 0 0 120 6689392 1467724 NULL 262 0 18188.26039132029 401.3199560014666 vector(0x01431658,0x01431678,0x01431698,0x014316b8,0,0,12360,5416,0x014316d8,0x01437b18) 5 Rows. -- 33 msec. SQL> </verbatim> Columns of interest are: * <code><nowiki>lm_n_rows</code></nowiki>: number of rows(triples) loaded; * <code><nowiki>lm_rows_per_s</code></nowiki>: number of rows(triples) loaded per second. ---+++Examples ---++++Benchmarks, Redux: BSBM and I/O * See [[http://www.openlinksw.com/weblog/oerling/?id=1667][Benchmarks, Redux (part 5): BSBM and I/O; HDDs and SSDs]] example test; ---++Related * [[VirtBulkRDFLoader][Virtuoso RDF Bulk Loader]] * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://www.openlinksw.com/dataspace/dav/wiki/Main/BenchmarksReduxSupportingFiles][Supporting Files for "Benchmarks, Redux" Blog Series]]
sioc:id
1f6724f137de2780ac1f1c0e2213d12f
sioc:link
n2:VirtTipsAndTricksGuideLDMeterUtility
sioc:has_container
n7:VOS
n12:has_services
n11:item
atom:title
VirtTipsAndTricksGuideLDMeterUtility
sioc:links_to
n4:VirtBulkRDFLoader n4:VirtTipsAndTricksGuide n19:BenchmarksReduxSupportingFiles n20:1667
atom:source
n7:VOS
atom:author
n8:this
atom:published
2017-06-13T05:38:22Z
atom:updated
2017-06-13T05:38:22Z
sioc:topic
n7:VOS