OptionStateRowLimit
Introduced Version1.51
Description

Maximum number of rows allowed in functions.

Maximum number of rows allowed in functions.

Used as an alternative for the environment variable MAX_STATE_LIMIT.

Attention

It is strongly recommended to not change this limit beyond its current default value as the consequences of doing so are cluster instability or cluster crashes.

If you experience a lot of query load, particularly from the sort(), table(), head(), and tail() functions, decreasing this limit can help alleviate said load, as it lowers the amount of events those functions are allowed to collect.