You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by gn01887818 <gn...@gmail.com> on 2019/02/14 03:31:45 UTC

Cpu usage cannot be improved

Use JDBC Client mode

There is an increase in the amount of writes, but the CPU utilization of the
machine where ignite DB is located has been maintained at 7%.
Want to ask what other settings can be opened, so that the cpu utilization
rate rises, improve the performance of writing?

Ps:
setDefaultDataRegionConfiguration has been set to 60gb



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
I have confirmed that I am using jstack...
Jstack -J-d64 -m processId
I generated jstackInfo.txt like this.
Still have to make other orders?

That's right, currently using a regular hard drive, it seems to be stuck on
the hard drive speed.
Thank you



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
I have confirmed that I am using jstack...
Jstack -J-d64 -m processId
I generated jstackInfo.txt like this.
Still have to make other orders?

That's right, currently using a regular hard drive, it seems to be stuck on
the hard drive speed.
Thank you



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by "ilya.kasnacheev" <il...@gmail.com>.
Hello!

You did not attach any files and I doubt stack traces will help much here.

Regards,



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
I have confirmed that I am using jstack...
Jstack -J-d64 -m processId
I generated jstackInfo.txt like this.
Still have to make other orders?

That's right, currently using a regular hard drive, it seems to be stuck on
the hard drive speed.
Thank you



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

Unfortunately, not much is going on in this thread dump (please use jstack
next time), but the main take away is that you seem to be using persistence.
If you are using persistence you should not expect CPU usage to hit 100%
since most of operations will be I/O-bound.

In this case you should review our persistence tuning tips:
https://apacheignite.readme.io/docs/durable-memory-tuning

Regards,
-- 
Ilya Kasnacheev


чт, 21 февр. 2019 г. в 07:04, gn01887818 <gn...@gmail.com>:

> Please look at the jstackInfo.txt file.
> Inside is the information when ignite db is executed.
> Thank you jstackInfo.txt
> <http://apache-ignite-users.70518.x6.nabble.com/file/t2299/jstackInfo.txt>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
Please look at the jstackInfo.txt file.
Inside is the information when ignite db is executed.
Thank you jstackInfo.txt
<http://apache-ignite-users.70518.x6.nabble.com/file/t2299/jstackInfo.txt>  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello again!

Please note that you should do that in the middle of load test (not before
or after).

Regards,
-- 
Ilya Kasnacheev


ср, 20 февр. 2019 г. в 15:32, Ilya Kasnacheev <il...@gmail.com>:

> Hello!
>
> You can use jstack utility.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> ср, 20 февр. 2019 г. в 13:55, gn01887818 <gn...@gmail.com>:
>
>> How to dump, is there a file reference? Thank you
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: Cpu usage cannot be improved

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

You can use jstack utility.

Regards,
-- 
Ilya Kasnacheev


ср, 20 февр. 2019 г. в 13:55, gn01887818 <gn...@gmail.com>:

> How to dump, is there a file reference? Thank you
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
How to dump, is there a file reference? Thank you



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

Please post thread dumps from all nodes then!

Regards,
-- 
Ilya Kasnacheev


ср, 20 февр. 2019 г. в 11:35, gn01887818 <gn...@gmail.com>:

> 1. Have tried stream mode
> streamingFlushFrequency=500
> streamingPerNodeBufferSize=512
>
> 2. Have tried System Pool, Queries Pool part,
> The default is 24 (machine cpu core number), raised to 80
>
> Still no way to improve the use of cpu.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
1. Have tried stream mode
streamingFlushFrequency=500
streamingPerNodeBufferSize=512

2. Have tried System Pool, Queries Pool part,
The default is 24 (machine cpu core number), raised to 80

Still no way to improve the use of cpu.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by gn01887818 <gn...@gmail.com>.
Thank you. I will give it a try.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cpu usage cannot be improved

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

Have you tried streaming mode (SET STREAMING)? Alternatively, try to
increase queries thread pool size:
https://apacheignite.readme.io/docs/thread-pools#section-queries-pool

Otherwise, you should collect thread dumps, see if there are pool
starvations or excessive locking (or show it for us to see).

Regards,
-- 
Ilya Kasnacheev


чт, 14 февр. 2019 г. в 06:31, gn01887818 <gn...@gmail.com>:

> Use JDBC Client mode
>
> There is an increase in the amount of writes, but the CPU utilization of
> the
> machine where ignite DB is located has been maintained at 7%.
> Want to ask what other settings can be opened, so that the cpu utilization
> rate rises, improve the performance of writing?
>
> Ps:
> setDefaultDataRegionConfiguration has been set to 60gb
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>