2016-04-17 1:03 GMT+02:00 Keith Medcalf <kmedcalf at dessus.com>:
> > Have another problem also. My CPU is about 15%, but the load average is
> > also about 15. (This is on a Linux system.) This results (sometimes) in a
> > very sluggish system. Can the load be a SQLite problem, or is it a Java
> > problem? (When the program is not running, the load average is a lot
> > lower.)
>
> You have slow CPU with multiple cores (15% means you probably have quad
> core -- probably with Intel Hyper-Slowness as well (as in not SMT), or you
> have dual-core SMT), and the dispatcher is brain-dead and dispatching the
> single threaded application on the same CPU as more critical OS workers
> resulting in swamping that core with compute use and preventing competing
> threads (such as the OS or the gooey) from being other than -- well --
> gooey.
>
> You claim this is Linux. There are many brands and flavours (and
> versions) or Linux, all tuned to behave differently. You do not specify
> the particular version and brand it is.
>
?It never hurts to give some extra information. I only expected SQLite
help. But I do not mind to get other help. :-D
The CPU is: Intel(R) Core(TM) i7-3632QM CPU @ 2.20GHz.
It is a little strange. It has four cores but Linux thinks it has eight.
None of the eight has a high load: sometimes one 60-70%, but most of the
time a lot lower.
The operating system is openSUSE 13.2.
free -m gives:
total used free shared buffers cached
Mem: 15923 15737 185 1300 105 8131
-/+ buffers/cache: 7500 8422
Swap: 2053 1659 394?
?RSSMemory usage for java
========================================
RSSMemory 6 MB by PID=9705
RSSMemory 54 MB by PID=9731
RSSMemory 75 MB by PID=28844
RSSMemory 112 MB by PID=18743
RSSMemory 121 MB by PID=28880
RSSMemory 345 MB by PID=1036
========================================
Total used RSSMemory: 713 MB
swap usage for java
========================================
swap 2 MB by PID=28880
swap 7 MB by PID=28844
swap 128 MB by PID=9731
swap 132 MB by PID=9705
swap 442 MB by PID=1036
========================================
Total used swap: 711 MB
The program has PID 18743 and does not use swap.
ps -l 18743 gives:
F S UID PID PPID C PRI NI ADDR SZ WCHAN TTY TIME CMD
0 S 1000 18743 28670 4 80 0 - 1718302 futex_ pts/12 45:29 java
RandomUUID CheckUUID.properties
?
My own psPid 18743 gives:
USER PID PPID TT START ELAPSED TIME STAT COMMAND
cecil 18743 28670 pts/12 Apr16 16:29:42 00:45:27 Sl+ java
RandomUUID CheckUUID.properties
So it does not have a high CPU usage about 5%.
I think I have to cancel the program, because I have:
23:03:12: Inserted 6.00e+07 UUID's
00:50:33: Inserted 6.10e+07 UUID's
02:56:31: Inserted 6.20e+07 UUID's
04:56:06: Inserted 6.30e+07 UUID's
06:53:03: Inserted 6.40e+07 UUID's
09:14:08: Inserted 6.50e+07 UUID's
That will take at least another 3 days.
This is the text based UUID. I expected it to take longer, but the blob
based took 4? hours. So that is a very big difference. But that is
something for another post.
It took almost half an hour to write, because of the sluggish behaviour.
:'-(
--
Cecil Westerhof
