ignite write big data in a pressure test, io write and read time tow high?

Question

I hava some write and find in ignite with sql.When I have a pressure test with 100 persons, ignite server's cpu is low, but iowait is two heigh, and io write and read time is two heigh. So I have some ways to reduce iowait? I use 2.7.6 version with two SSD machines as cluster.

this is iowait time picture [1]: https://i.stack.imgur.com/P0bka.png [2]: https://i.stack.imgur.com/hyfv1.png this is iowait cpu picture

alamar · Answer 1 · 2020-09-04T09:23:53.527

0

In persistent scenarios, you are bound by WAL writes. You can try changing WAL Mode to LOG_ONLY to mitigate these peaks slightly.

I recommend making checkpoints further apart (by changing "checkpoint frequency" setting, in ms) and maybe increasing "checkpoint page buffer".

edited Sep 04 '20 at 09:23

answered Aug 14 '20 at 14:26

alamar

18,729
4
64
97

Do you know good idea to improve WAL writes very much? – zhangzl Aug 24 '20 at 07:39
LOG_ONLY is default model，I don't change. – zhangzl Aug 24 '20 at 07:44
Then, I recommend making checkpoints further apart (by changing checkpoint frequency setting, in `ms`) and maybe increasing checkpoint page buffer. – alamar Sep 04 '20 at 09:23

ignite write big data in a pressure test, io write and read time tow high?

1 Answers1