[Nepomuk] general questions: virtuoso-t & nepomukstorage, desktopsearch
Sebastian Trüg
trueg at kde.org
Fri Oct 14 12:40:54 UTC 2011
and when this happens which processes are using a lot of cpu?
On 10/14/2011 11:00 AM, Matthias Lechner wrote:
>> Yes, it seems to me this is the not so great isql version from unixODBC.
>> You need the one from Virtuoso. I am not sure if your distribution
>> provides packages for it though. Here on Gentoo it is called isql-v.
>
> Thanks for your hint. Here on Ubuntu the command is isql-vt. Put the output of
> status() below, I hope that tells you something.
>
> Reagards,
> Mat
>
> SQL> status();
> REPORT
> VARCHAR
> _______________________________________________________________________________
>
> OpenLink Virtuoso Server
> Version 06.01.3127-pthreads for Linux as of Aug 3 2010
> Started on: 2011/10/11 08:56 GMT+120
> Lite Mode
>
> Database Status:
> File size 1623195648, 198144 pages, 57409 free.
> 7400 buffers, 7390 used, 617 dirty 0 wired down, repl age 209384 0 w. io 0
> w/crsr.
> Disk Usage: 77058 reads avg 4 msec, 1% r 0% w last 78 s, 241263 writes,
> 493 read ahead, batch = 51. Autocompact 4585 in 3436 out, 25% saved.
> Gate: 987 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
> Log =
> /home/mat/.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-
> virtuoso.trx, 339349 bytes
> 139596 pages have been changed since last backup (in checkpoint state)
> Current backup timestamp: 0x0000-0x00-0x00
> Last backup date: unknown
> Clients: 321 connects, max 22 concurrent
> RPC: 3598765 calls, -302 pending, 5 max until now, 0 queued, 7450 burst reads
> (0%), 5 second brk=23408640
> Checkpoint Remap 0 pages, 0 mapped back. 649 s atomic time.
> DB master 198144 total 57409 free 0 remap 0 mapped back
> temp 256 total 251 free
>
> Lock Status: 0 deadlocks of which 0 2r1w, 45 waits,
> Currently 1 threads running 0 threads waiting 0 threads in vdb.
> Pending:
>
> Client 1111:1:-8: Account: dba, 10254 bytes in, 9738 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-320: Account: dba, 2659 bytes in, 799 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-3: Account: dba, 26171 bytes in, 1250479 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-182: Account: dba, 35629 bytes in, 10131 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-170: Account: dba, 24763 bytes in, 11685474 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:321: Account: dba, 204 bytes in, 255 bytes out, 1 stmts.
> PID: 24216, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 1 threads.
> Locks:
>
> Client 1111:1:-167: Account: dba, 2428666 bytes in, 1748502 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-51: Account: dba, 34850 bytes in, 2821546 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-25: Account: dba, 41244 bytes in, 12924372 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-11: Account: dba, 42958977 bytes in, 7661076 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-7: Account: dba, 7082356 bytes in, 3336139 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-5: Account: dba, 25263 bytes in, 35535 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-6: Account: dba, 458107131 bytes in, 531006150 bytes out, 1
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-12: Account: dba, 44632996 bytes in, 8262335 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-10: Account: dba, 587021 bytes in, 827168 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-166: Account: dba, 2567755 bytes in, 1500304 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-100: Account: dba, 77206 bytes in, 127731 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-164: Account: dba, 1262734 bytes in, 6862738 bytes out, 0
> stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-22: Account: dba, 21364 bytes in, 5983 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
> Client 1111:1:-24: Account: dba, 33713 bytes in, 16966542 bytes out, 0 stmts.
> PID: 5889, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 0 threads.
> Locks:
>
>
> Running Statements:
> Time (msec) Text
> 1 sparql delete from graph <urn:crappyinference2:inferredtriples> {
> <urn:nepomuk:l
> 5 status()
>
>
> Hash indexes
>
>
> 134 Rows. -- 8 msec.
> SQL>
>
>
>
> _______________________________________________
> Nepomuk mailing list
> Nepomuk at kde.org
> https://mail.kde.org/mailman/listinfo/nepomuk
>
More information about the Nepomuk
mailing list