Andrejs,
On 9 Apr 2014, at 12:17, Andrejs Abele <andr...@sindicetech.com> wrote:
> Hi Hugh,
> 1. yes it was client side loader that crashes
[Hugh] Why does the java client app crash if all it is really doing is activate
the "rdf_loader_run()" function on the Virtuoso server ?
> 2. we run only one loader, to keep our client side loader as simple as
> possible. But based on your recommendation we increased number of loaders
> and speed improved a little bit.
[Hugh] It will improve the speed having multiple loaders but if you run out of
memory and have to swap to disk the load rate will still drop significantly.
> 3. Cloud you pleas clarify what do you mean with swapping? Does virtuoso do
> it's own swapping, as when I monitored our system, there was no swapping on
> OS level ?
[Hugh] This is standard OS swapping to disk, see:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagswapping
Regards
Hugh
>
> Below is output of status()
> OpenLink Virtuoso Server
> Version 07.10.3207-pthreads for Linux as of Mar 13 2014
> Started on: 2014-04-08 16:17 GMT+0
>
> Database Status:
> File size 0, 14680064 pages, 7729259 free.
> 2400000 buffers, 2316694 used, 2 dirty 0 wired down, repl age 1253701 0 w.
> io 0 w/crsr.
> Disk Usage: 3198691 reads avg 4 msec, 0% r 0% w last 0 s, 7346381 writes
> flush 76.56 MB,
> 73305 read ahead, batch = 16. Autocompact 194490 in 161323 out, 17%
> saved col ac: 2534798 in 9% saved.
> Gate: 116183 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
> Log = /usr/local/virtuosoCtl/virtuoso.trx, 1287 bytes
> 6117570 pages have been changed since last backup (in checkpoint state)
> Current backup timestamp: 0x0000-0x00-0x00
> Last backup date: unknown
> Clients: 16 connects, max 1 concurrent
> RPC: 102 calls, -14 pending, 1 max until now, 0 queued, 0 burst reads (0%), 2
> second 0M large, 828M max
> Checkpoint Remap 831098 pages, 0 mapped back. 1120 s atomic time.
> DB master 14680064 total 7729259 free 831098 remap 1 mapped back
> temp 107520 total 107513 free
>
> Lock Status: 0 deadlocks of which 0 2r1w, 17 waits,
> Currently 1 threads running 0 threads waiting 0 threads in vdb.
> Pending:
>
> Client 1111:16: Account: dba, 205 bytes in, 257 bytes out, 1 stmts.
> PID: 24134, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 1 threads.
> Locks:
>
>
> Running Statements:
> Time (msec) Text
> 299 status()
>
>
> Hash indexes
>
>
> 37 Rows. -- 299 msec.
>
> Regards,
> Andrejs
> ------------------------------------------------------------------------------
> Put Bad Developers to Shame
> Dominate Development with Jenkins Continuous Integration
> Continuously Automate Build, Test & Deployment
> Start a new project now. Try Jenkins in the cloud.
> http://p.sf.net/sfu/13600_Cloudbees_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
