Not logged in : Login

About: VirtTipsAndTricksGuideLDMeterUtility     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • VirtTipsAndTricksGuideLDMeterUtility
maker
Title
  • VirtTipsAndTricksGuideLDMeterUtility
isDescribedUsing
has creator
attachment
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 ldmeter.sql script into your Virtuoso instance; 1 Run ld_meter_run(N) to set the time interval in seconds in which the meter should be run which gets written to the ld_metric table which will contain data for the form: 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> Columns of interest are: * lm_n_rows: number of rows(triples) loaded; * lm_rows_per_s: 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]]
id
  • 1f6724f137de2780ac1f1c0e2213d12f
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • VirtTipsAndTricksGuideLDMeterUtility
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:38:22Z
atom:updated
  • 2017-06-13T05:38:22Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is links to of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git132 as of May 12 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3332 as of Sep 11 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 2 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software