[Nepomuk] general questions: virtuoso-t & nepomukstorage, desktopsearch

Fri Oct 14 13:26:38 UTC 2011

weird, virtuoso is not doing any long operations here. That only leaves
a lot of small ones.
Could you maybe debug into the storage service to see what it does via
"thread apply all bt".

Thanks
Sebastian

On 10/14/2011 03:11 PM, Matthias Lechner wrote:
> Ok, here's the output during the spike. Just for completeness, virtuoso-t and 
> nepomukservicestub nepomukstorage are using all the CPU.
> 
> 
> 
> 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, 57515 free.
>   7400 buffers, 7389 used, 318 dirty 0 wired down, repl age 216030 0 w. io 0 
> w/crsr.
>   Disk Usage: 80550 reads avg 4 msec, 1% r 0% w last  6 s, 261572 writes,
>     494 read ahead, batch = 51.  Autocompact 4912 in 3684 out, 24% saved.
> Gate:  991 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, 213608 bytes
> 139789 pages have been changed since last backup (in checkpoint state)
> Current backup timestamp: 0x0000-0x00-0x00
> Last backup date: unknown
> Clients: 347 connects, max 23 concurrent
> RPC: 4064720 calls, -329 pending, 5 max until now, 0 queued, 8336 burst reads 
> (0%), 5 second brk=23408640
> Checkpoint Remap 0 pages, 0 mapped back. 714 s atomic time.
>     DB master 198144 total 57515 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:-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, 37174 bytes in, 10560 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, 678 bytes in, 22787 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, 43084 bytes in, 12972755 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, 42959499 bytes in, 7661288 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, 8134586 bytes in, 3820649 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, 521783694 bytes in, 605473438 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, 1434191 bytes in, 7690271 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
>            3 status()
>  
>  
> Hash indexes
>  
> 
> 128 Rows. -- 5 msec.
> SQL>
> 
> 
> _______________________________________________
> Nepomuk mailing list
> Nepomuk at kde.org
> https://mail.kde.org/mailman/listinfo/nepomuk
> 