runtime_bloom_filter_max_size specifies the maximum memory usage in bytes allowed for the runtime filter of the BLOOM_FILTER type.
Note
This variable is available in OceanBase Database V4.2.0 and later.
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 2147483648 |
| Value range | [0, 9223372036854775807] |
| Applicable scope |
|
| Read-only? | No |
| Involved in serialization? | Yes |
| Effective only after restart? | No |
Sample code
set runtime_bloom_filter_max_size = 2 * 1024 * 1024 * 1024;
set global runtime_bloom_filter_max_size = 20 * 1024 * 1024;