Hi Hugh,
my apologies for the late reply... been busy again...
On Wed, Oct 16, 2013 at 4:19 AM, Hugh Williams <hwilli...@openlinksw.com> 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
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
