2 cores are just not enough for 100 running simultaneously queries, of course, you will see a lot of context-switching, which will lead to the slowness of the part of queries.
пн, 10 дек. 2018 г. в 10:35, Skollur <[email protected]>: > Enclosed CPU/Thread usage. Ignite became super slow after applying > below. I > am still not sure how many threads are required to span 100 queries > simultaneously. I am seeing CPU is hitting almost 100%. > > cfg.setQueryThreadPoolSize(16); > cfg.setSystemThreadPoolSize(16); > cfg.setPublicThreadPoolSize(16); > cfg.setServiceThreadPoolSize(16); > cfg.setRebalanceThreadPoolSize(10); > > Will below helps? > //ccfg.setSqlOnheapCacheEnabled(true); //ccfg.setOnheapCacheEnabled(true); > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
