Setting the threshold limits for SQL oeprations

[Naveen <na...@gmail.com>]

Hello Everyone

I have seen somewhere that we can set the limit for all the resources that
can be allocated  for SQL operations, like you can set the limit for heap
utilization for all the SQL operations, similarly CPU etc. if it goes beyond
those limits, SQL operations will be failed with a appropriate error
message.

Can you please let me know what are those limits we can set and how do we
set

We are using ignite 2.8.1

Thanks
Naveen



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

Re: Setting the threshold limits for SQL oeprations

[Ilya Kasnacheev <il...@gmail.com>]

Hello!

I don't think it is possible since the H2 engine does not provide options
to limit CPU and heap AFAIK. Ignite community have decided to not rely on
forked H2 engine as e.g. recent GridGain does.

Maybe this will change when Calcite is introduced, and limiting will be
possible.

You can tune query pool to change how many parallel query threads may
utilize CPU, you may also tune query parallelism to uptick CPU usage by
some queries.

Regards,
-- 
Ilya Kasnacheev


вс, 2 мая 2021 г. в 16:33, Naveen <na...@gmail.com>:

> Hello Everyone
>
> I have seen somewhere that we can set the limit for all the resources that
> can be allocated  for SQL operations, like you can set the limit for heap
> utilization for all the SQL operations, similarly CPU etc. if it goes
> beyond
> those limits, SQL operations will be failed with a appropriate error
> message.
>
> Can you please let me know what are those limits we can set and how do we
> set
>
> We are using ignite 2.8.1
>
> Thanks
> Naveen
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>