Pascal,
On 30 Jul 2014, at 13:59, Pascal Heus <pascal.h...@mtna.us> wrote:
> Have a couple of questions on the Conductor Sysadmin dashboard related
> to the client connection counts:
> - Is it correct that the "clients connected" is the number if
> connections opened and closed since server start up?
[Hugh] Yes
> - Under clients, the number of connections I see there seem to be higher
> than the count I would expect. I would essentially expect this to be
> equal to 1 from an idle web application server using virtuoso as back
> end (though the Java virtuoso pool). But this is often 10+. Where might
> the other counts be coming from? I assume one if from the conductor UI
> itself.
[Hugh] Connections under the "Clients" section are for SQL (including
ODBC/JDBC/ADO.Net etc SQL based connections) made to the server and not HTTP
connections made by the Conductor which would be made from the HTTP Thread pool
in the "HTTP Server" section.
> - Noted as well as this goes up by 1 eachg time I reload the conductor
> dashboard UI. In general, when are these statistics updated?
[Hugh] They should be updated immediately but as said you would see Conductor
connects in the HTTP Server section.
> - Is there an equivalent isql function that could also give mo more
> details on the individual connections?
[Hugh] The Dashboard output includes many of the parameters form the isql
"status();" command output and others:
SQL> status();
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso Server
Version 07.10.3211-pthreads for Darwin as of Jul 14 2014
Started on: 2014-07-30 01:39 GMT+1
Database Status:
File size 0, 11264 pages, 8098 free.
100000 buffers, 880 used, 72 dirty 0 wired down, repl age 0 0 w. io 0 w/crsr.
Disk Usage: 1053 reads avg 3 msec, 0% r 0% w last 46 s, 716 writes flush
0 MB,
23 read ahead, batch = 18. Autocompact 0 in 0 out, 0% saved.
Gate: 118 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = /usr/local/vos7/database/virtuoso.trx, 7805 bytes
3065 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 2 connects, max 1 concurrent
RPC: 14 calls, 0 pending, 1 max until now, 0 queued, 0 burst reads (0%), 0
second 0M large, 23M max
Checkpoint Remap 0 pages, 0 mapped back. 15 s atomic time.
DB master 11264 total 8098 free 0 remap 0 mapped back
temp 1024 total 1019 free
Lock Status: 0 deadlocks of which 0 2r1w, 115 waits,
Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:
Client 1111:2: Account: dba, 203 bytes in, 256 bytes out, 1 stmts.
PID: 22473, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:
Running Statements:
Time (msec) Text
86 status()
Hash indexes
37 Rows. -- 86 msec.
SQL>
Virtuoso also has the "sys_stats" function which enables most of the relevant
params of the server to be determined as detailed at:
http://docs.openlinksw.com/virtuoso/fn_sys_stat.html
Regards
Hugh
> much appreciated
> *P
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
