Re: [Virtuoso-users] how to 'debug' VOS7 performance?

[Egon W. <ego...@gm...>]

Hi Hugh,

my apologies for the late reply... been busy again...

On Wed, Oct 16, 2013 at 4:19 AM, Hugh Williams <hwi...@op...> wrote:
> What is the current triple count of your Virtuoso Server instance.

129857455

> Also when the database is "warm" can you please provide the output of running the "status();" command from isql to see the state of the database.

------------------------------------------------------------------------------------------------
SQL> status();
REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso  Server
Version 07.00.3203-pthreads for Linux as of Aug 12 2013
Started on: 2013-12-05 07:42 GMT+1

Database Status:
  File size 5972688896, 729088 pages, 266152 free.
  680000 buffers, 137785 used, 1 dirty 0 wired down, repl age 0 0 w.
io 0 w/crsr.
  Disk Usage: 138686 reads avg 0 msec, 0% r 0% w last  112 s, 6321 writes,
    532 read ahead, batch = 256.  Autocompact 0 in 0 out, 0% saved.
Gate:  2916 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = virtuoso.trx, 467 bytes
462883 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 1 connects, max 1 concurrent
RPC: 6 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads
(0%), 0 second 0M large, 126M max
Checkpoint Remap 0 pages, 0 mapped back. 16 s atomic time.
    DB master 729088 total 266152 free 0 remap 0 mapped back
   temp  83200 total 83195 free

Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
   Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:

Client 1113:1:  Account: dba, 337 bytes in, 2464 bytes out, 1 stmts.
PID: 22729, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:


Running Statements:
 Time (msec) Text
          70 status()


Hash indexes


37 Rows. -- 71 msec.
------------------------------------------------------------------------------------------------

I have no idea how to start with this feedback or how to link this to
settings. Is there documentation that explains that?

Egon

-- 
Dr E.L. Willighagen
Postdoctoral Researcher
Department of Bioinformatics - BiGCaT
Maastricht University (http://www.bigcat.unimaas.nl/)
Homepage: http://egonw.github.com/
LinkedIn: http://se.linkedin.com/in/egonw
Blog: http://chem-bla-ics.blogspot.com/
PubList: http://www.citeulike.org/user/egonw/tag/papers
ORCID: 0000-0001-7542-0286